Re: [GENERAL] manage changes to views having depencies

2009-01-01 Thread Berend Tober
Eric Worden wrote: 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

Re: [GENERAL] manage changes to views having depencies

2008-12-31 Thread Scott Marlowe
On Wed, Dec 31, 2008 at 9:57 PM, Eric Worden wrote: > 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

[GENERAL] manage changes to views having depencies

2008-12-31 Thread Eric Worden
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 approx