Re: [GENERAL] live metadata changes v8.3.4

2011-09-28 Thread David Fetter
On Tue, Sep 27, 2011 at 01:51:42PM -0700, Gauthier, Dave wrote: > Hi: > > 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. > > In the

Re: [GENERAL] live metadata changes v8.3.4

2011-09-27 Thread Richard Broersma
On Tue, Sep 27, 2011 at 1:51 PM, Gauthier, Dave 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