| From: | Hannu Krosing <hannu(at)skype(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 12:36:16 |
| Message-ID: | 1149770176.4537.14.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Ühel kenal päeval, N, 2006-06-08 kell 08:38, kirjutas Albert Cervera
Areny:
> Hi,
> after starting this thread
> http://archives.postgresql.org/pgsql-hackers/2006-05/msg00222.php, I thought
> I'd finally go for making foreign keys my own way instead of trying to patch
> PostgreSQL. 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.
remember that you must manage both ends of foreign key. and you have to
lock the other table while changing values at either end.
--
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia
Skype me: callto:hkrosing
Get Skype for free: http://www.skype.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2006-06-08 13:05:12 | Re: How to avoid transaction ID wrap |
| Previous Message | dananrg | 2006-06-08 12:21:07 | Fabian Pascal and RDBMS deficiencies in fully implementing the relational model |