Guyren Howe wrote:
I’ve a set of interrelated views. I want to drop a column from a table and from
all the views that
cascade from it.
I’ve gone to the leaf dependencies and removed the field from them. But I can’t
remove the field
from the intermediate views because Postgres doesn’t appear to be clever enough
to see that the
leafs no longer depend on the column. Or did I just miss one?
In general, this seems like a major weakness expressing a model in Postgres (I
get that any such
weakness derives from SQL; that doesn’t stop me wanting a solution).
Thoughts? Comments?
This usually involves a pg_dump in the custom format, editing the list file, creating a script with
pg_restore.
I described a way I have had success with it at one point at
https://www.postgresql.org/message-id/55C3F0B4.5010600%40computer.org
-- B
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
