table2
CASCADE; etcINSERT INTO table1 VALUES blah blah ...INSERT INTO table2
VALUES blah blah ...etcCOMMIT;
Best regards, Daniel
--- On Mon, 13/9/10, Tom Lane wrote:
From: Tom Lane
Subject: Re: [BUGS] BUG #5654: Deferred Constraints don't work
To: "Daniel Howard"
Cc: pgsql-bugs@p
"Daniel Howard" writes:
> The command
> SET CONSTRAINTS ALL DEFERRED
> seems to have no effect.
Yes it does. For instance, in your example setting the mode to deferred
will allow you to insert an items row that doesn't match any users row:
regression=# insert into items(user_id) values(42);
ERR
The following bug has been logged online:
Bug reference: 5654
Logged by: Daniel Howard
Email address: cheesero...@yahoo.com
PostgreSQL version: 8.4.4
Operating system: Linux (Ubuntu 10.04.1)
Description:Deferred Constraints don't work
Details:
The command
SET CONSTR
