On Tue, 2010-04-13 at 00:04 -0500, Jaime Casanova wrote: > On Mon, Apr 12, 2010 at 10:56 PM, Kevin Kempter > <[email protected]> wrote: > > Hi All; > > > > I have a ddl file with a drop view and a create view statement in it. If I > > try > > to run it through the EXECUTE SCRIPT call then I get this: > > > > > > > > DDL Statement failed - PGRES_FATAL_ERROR > > > > Does EXECUTE SCRIPT not allow CREATE VIEW statements? > > > > > > and what failed? the drop or the create view? you're not allowed to > drop a view if some object (like another view) depends on it
I would try running the exact SQL on all databases in the cluster directly with BEGIN/ROLLBACK and make sure that runs everywhere. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
