pgsql-server/src backend/commands/tablecmds.c ...

Started by Tom Lanealmost 23 years ago1 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl@svr1.postgresql.org 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.