Re: [GENERAL] ERROR: cannot alter type of a column used by a view or rule

OK!   Thanks.Stephan Szabo <[EMAIL PROTECTED]> wrote: On Wed, 16 Feb 2005, Daniel Naschenweng wrote:> I create this table:> create table teste (campo1 varchar(20));>> And this view:> create view vteste as select * from teste;>> When I try change the type of the column raise thir error:> db=# alter

Re: [GENERAL] ERROR: cannot alter type of a column used by a view

On Wed, 16 Feb 2005, Daniel Naschenweng wrote: > I create this table: > create table teste (campo1 varchar(20)); > > And this view: > create view vteste as select * from teste; > > When I try change the type of the column raise thir error: > db=# alter table teste alter column campo1 type varchar(