hi
I have situation, where I need to change datatype of column.
But when I do:
alter table xx alter column yy type zz;
i get error:
ERROR: cannot alter type of a column used by a view or rule
DETAIL: rule _RETURN on view some_view depends on column "yy"
how can I get a list of all such views (in a sqlish way, so I could make a
query to return all needed objects that need to be dropped/recreated).
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
