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

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

From
tgl@svr1.postgresql.org (Tom Lane)
Date:
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.