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 ra

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

Hi, 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(30);ERROR: cannot alter type of a column used by a view or rul