| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Dennis Gearon <gearond(at)cvc(dot)net> |
| Cc: | <gitarrerik(at)musiker(dot)nu>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Server error |
| Date: | 2003-05-08 22:14:53 |
| Message-ID: | 20030508151105.V48282-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 8 May 2003, Dennis Gearon wrote:
> it does a full scan of the table's child and parent columns upon
> creation of a foreign key?
It currently runs the trigger once per row in the referencing table.
Doing a single select with not exists will almost certainly be faster, but
that's waiting for someone else to decide to do it or me to get time to do
it. :)
Some form of check is required, AFAIK however, because if the constraint
isn't satisified at the end of the alter table an error should be thrown.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kathy Zhu | 2003-05-08 22:20:08 | Re: jdbc connection process size |
| Previous Message | Dennis Gearon | 2003-05-08 22:06:21 | Re: Server error |