Sent from my iPad

On Apr 12, 2010, at 10:04 PM, Melvin Davidson <melvin6925 at yahoo.com> 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 <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...
> 
> 
> 
> 

No set role - just a straight "create view"

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