On Tue, 2010-04-13 at 00:04 -0500, Jaime Casanova wrote:
> On Mon, Apr 12, 2010 at 10:56 PM, Kevin Kempter
> <kevink at consistentstate.com> 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.