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

2005-02-16 Thread Daniel Naschenweng
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

2005-02-16 Thread Stephan Szabo
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(

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

2005-02-16 Thread Daniel Naschenweng
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