On Tue, 25 Mar 2008, kevin kempter wrote: > I've placed this sql in a script: > > psql my_db <<! > begin; > SET CONSTRAINTS ALL DEFERRED ; > delete from account where 1 = 1; > delete from cust where 1 = 1; > delete from cust_type where 1 = 1; > delete from cust_orders where 1 = 1; > commit; > ! > > The tables have relationships, however I expect the 'SET CONSTRAINTS > ALL DEFERRED' to defer constraint checks.
IIRC it's defined to only defer constraints created with DEFERRABLE and/or INITIALLY DEFERRED. The default is NOT DEFERRABLE. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
