Jaime Casanova jcasanov at systemguards.com.ec
Mon Apr 12 22:04:38 PDT 2010
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

-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157


More information about the Slony1-general mailing list