| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Dennis Gearon <gearond(at)cvc(dot)net> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: foreign key constraint |
| Date: | 2003-03-04 16:21:30 |
| Message-ID: | 20030304081751.N53493-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 4 Mar 2003, Dennis Gearon wrote:
> OR, how is it possible to add foreign key constraints, ('cross constraints'), between two tables.
> I tried it in a transaction, but it didn't work. The first constraint in the table definition
> was DEFERRABLE INITIALLY DEFERRED, but I don't think the parser cared :-) I got this error:
Tom dealt with the first part. I'll deal with this one. The initially
deferred refers to the the check time of the constraint, however to make
the constraint requires the table to be there. I think this is defensible
since you need permissions at the table constraint creation time on the
other table which is pretty much impossible if it doesn't exist. :)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-03-04 16:25:31 | Re: Q from new user about postgresql? |
| Previous Message | Rod Taylor | 2003-03-04 16:16:20 | Re: [PATCHES] ALTER SEQUENCE |