On Tue, Sep 27, 2011 at 1:51 PM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> wrote: > How does one make a metadata change to a DB that's actively being used. > Specifically, I want to drop a view, drop some columns from a table that's > used in the view, recreate the view without those columns. BEGIN TRANSACTION; DROP VIEW someView ...; ALTER TABLE DROP COLUMN someColumn1, DROP COLUMN someColumn2; CREATE VIEW someView AS ...; COMMIT; --Wait for pre-existing locks to complete and hope your client app doesn't break. -- Regards, Richard Broersma Jr. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
