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 <kevink at consistentstate.com> wrote:

From: Kevin Kempter <kevink at consistentstate.com>
Subject: [Slony1-general] EXECUTE SCRIPT failure
To: slony1-general at lists.slony.info
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...
_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100412/c27014e5/attachment.htm