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

From: Daniel Naschenweng <daniel_blumenau(at)yahoo(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: cannot alter type of a column used by a view or rule
Date: 2005-02-16 11:22:28
Message-ID: 20050216112228.44392.qmail@web42103.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 rule
DETAIL: rule _RETURN on view vteste depends on column "campo1"

My question is: Who I can create a "select" no system catalog to return views with this column befor raise error?

Thanks,

Daniel


---------------------------------
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador do Yahoo! agora.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marco Colombo 2005-02-16 12:46:55 Re: Lost rows/data corruption?
Previous Message Nageshwar Rao 2005-02-16 11:16:09 insert data from an microsoft excel