<html><body bgcolor="#FFFFFF"><div><br><br>Sent from my iPad</div><div><br>On Apr 12, 2010, at 10:04 PM, Melvin Davidson <<a href="mailto:melvin6925@yahoo.com">melvin6925@yahoo.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td valign="top" style="font: inherit;">Kevin,<br><br>Yes, you can do a CREATE VIEW with EXECUTE SCRIPT. But that is probably not the cause of your problem.<br><br>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.<br><br><div id="RTEContent"><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font><br> <font size="3"> </font><font size="3"><span style="font-weight: bold; font-family: courier;"><br></span></font></div><br><br>--- On <b>Mon, 4/12/10, Kevin Kempter <i><<a href="mailto:kevink@consistentstate.com">kevink@consistentstate.com</a>></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255);
margin-left: 5px; padding-left: 5px;"><br>From: Kevin Kempter <<a href="mailto:kevink@consistentstate.com">kevink@consistentstate.com</a>><br>Subject: [Slony1-general] EXECUTE SCRIPT failure<br>To: <a href="mailto:slony1-general@lists.slony.info"><a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a></a><br>Date: Monday, April 12, 2010, 10:56 PM<br><br><div class="plainMail">Hi All;<br><br>I have a ddl file with a drop view and a create view statement in it. If I try <br>to run it through the EXECUTE SCRIPT call then I get this:<br><br><br><br></div><div class="plainMail"><br>DDL Statement failed - PGRES_FATAL_ERROR<br><br>Does EXECUTE SCRIPT not allow CREATE VIEW statements?<br><br><br>Thanks in advance...</div><div class="plainMail"><br></div><div class="plainMail"><br></div><div class="plainMail"><br></div></blockquote></td></tr></tbody></table><br>
</div></blockquote><div class="plainMail"><br></div><div class="plainMail">No set role - just a straight "create view"</div><div class="plainMail"><br></div></body></html>