Dferred constraints not deferred? - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Dferred constraints not deferred?
Date
Msg-id 3E3E3C97.2050100@mega-bucks.co.jp
Whole thread Raw
Responses Re: Dferred constraints not deferred?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
I'm trying to drop a table inside a transaction with all constraints
deferred, and then re-create the table, but PG won't let me ..

TAL=# begin;
BEGIN
TAL=# SET CONSTRAINTS ALL DEFERRED;
SET CONSTRAINTS
TAL=# drop table invoices;
NOTICE:  constraint $1 on table invoice_admin_memo depends on table invoices
NOTICE:  constraint $1 on table req_dlv_date depends on table invoices
NOTICE:  constraint $1 on table invoice_li depends on table invoices
NOTICE:  constraint $1 on table invoice_emails depends on table invoices
ERROR:  Cannot drop table invoices because other objects depend on it
         Use DROP ... CASCADE to drop the dependent objects too

I tought the point of "SET CONSTRAINTS ALL DEFERRED" was to make
transaction skip constraint checking until the end of a transaction ...
But in this case the foreign key constraints a checked right away ...

What I would like is to drop the table and recreate it without having PG
complain about these FK constraints until the very end of the
transaction (at which time all data will be consistant) ... is this
possible?

Thanks,

Jc


pgsql-general by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Postgre vs SAP Db
Next
From: will trillich
Date:
Subject: Re: History