| From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
|---|---|
| To: | Albert Cervera Areny <albertca(at)hotpop(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: More on inheritance and foreign keys |
| Date: | 2006-06-08 07:59:46 |
| Message-ID: | DE6089F9-9578-4C13-AF0A-A4DA5288E7A6@seespotcode.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Jun 8, 2006, at 15:38 , Albert Cervera Areny wrote:
> However, I've realized that managing foreign keys with my own
> PL/SQL or C function isn't possible as I need DEFERRED checks which
> are
> currently only available for foreign keys.
I don't know enough about your situation to be sure if this will work
or not, but perhaps you want to look at CREATE CONSTRAINT TRIGGER.
They're deferred to the end of the transaction.
http://www.postgresql.org/docs/8.1/interactive/sql-createconstraint.html
In the hope that this helps,
Michael Glaesemann
grzm seespotcode net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2006-06-08 08:17:00 | Re: That EXPLAIN ANALYZE patch still needs work |
| Previous Message | Albert Cervera Areny | 2006-06-08 06:38:10 | More on inheritance and foreign keys |