Foreign keys

From: "MAR - Secretariado Geral" <secretariadogeral(at)acra(dot)pt>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Foreign keys
Date: 2006-09-09 22:55:58
Message-ID: 000601c6d463$208cb160$0500a8c0@SECGERAL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi everybody,

First of all i'de like to apolagize cause my poor english. After this, i shuould say that i beleavee a year ago i brought this problem to the community but i donn't remember some answering about it. The problem is:

Every time a users misses a external refrenced key the PGSql raises an exception.
Well as far as i realise if we had 5 or 10 Foreign keys during an Insert/Update transaction only exception should be raised reporting all erros/messages after last external refrenced field missed at one time,not one by one.
Well, in order to implement this idea we will need to desable the built-in refencial integrety and build it all by your self- all the validation (look-ups etc..) before insert/update If tg_op='insert' or tg_op='update' then as people do with non relational Databases - all hand-made. Well, this is very hard to beleave!!! I must be missing something.

Please i'must be wrong can some one explain me what i'm missing?

Thanks in Advance

Mário Reis


Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-09-10 00:41:59 Re: ISBN/ISSN/ISMN/EAN13 module
Previous Message Jeremy Kronuz 2006-09-09 22:48:10 Re: ISBN/ISSN/ISMN/EAN13 module