]> granicus.if.org Git - postgresql/commit
During ALTER TABLE ADD FOREIGN KEY, try to check the existing rows using
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 6 Oct 2003 16:38:28 +0000 (16:38 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 6 Oct 2003 16:38:28 +0000 (16:38 +0000)
commitfec58f6c3f17ba6acbba65a73ca736578041677f
tree7c15e8bbc8a28aeb9e15b30e72068a7b636b945f
parenta0ab31dcc646a1bc25360999d388fd2a8408dc30
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.
src/backend/commands/tablecmds.c
src/backend/utils/adt/ri_triggers.c
src/include/commands/trigger.h