CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: [EMAIL PROTECTED] 03/10/06 13:38:28
Modified files:
src/backend/commands: tablecmds.c
src/backend/utils/adt: ri_triggers.c
src/include/commands: trigger.h
Log message:
During ALTER TABLE ADD FOREIGN KEY, try to check the existing rows using
a single LEFT JOIN query instead of firing the check trigger for each
row individually. Stephan Szabo, with some kibitzing from Tom Lane and
Jan Wieck.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
