Can anyone recommend a reasonably efficient system for changing a view definition (say by adding a column) when it has a bunch of dependent functions?
Right now I work with the output from pg_dump to recreate things after doing "DROP VIEW ... CASCADE". But the pg_dump schema output is only approximately sorted by dependencies, and "create table..." is sprinkled all through it. That means I have to carefully comb through and select the pieces I need. Is there a way to just script the view definitions, then the functions? Or maybe I'm looking at it the wrong way? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
