Sent from my iPad
On Apr 12, 2010, at 10:04 PM, Melvin Davidson <[email protected]> wrote: > Kevin, > > Yes, you can do a CREATE VIEW with EXECUTE SCRIPT. But that is probably not > the cause of your problem. > > Are you by any chance doing a SET ROLE at the beginning of the script? If so, > then you must also do another SET ROLE back to the original Slony superuser > before exiting. If that is not the case, then perhaps you can enlighten us by > showing us the contents of the script, otherwise, it's hard to guess at the > unknown. > > Melvin Davidson > > > > --- On Mon, 4/12/10, Kevin Kempter <[email protected]> wrote: > > From: Kevin Kempter <[email protected]> > Subject: [Slony1-general] EXECUTE SCRIPT failure > To: [email protected] > Date: Monday, April 12, 2010, 10:56 PM > > 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? > > > Thanks in advance... > > > > No set role - just a straight "create view"
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
