projects / users / bernd / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 2f4a1e0) | patch
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)
commit32e815385a2084941fad8bc3a3c9652a8b08ed87
treeef2e20a724d31dcb4de00a4f375aff4ab8ecd84dtree
parent2f4a1e08940e7ba9348279b00f0847e2763663cdcommit | diff
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 diff | blob | blame | history
src/backend/utils/adt/ri_triggers.c diff | blob | blame | history
src/include/commands/trigger.h diff | blob | blame | history
Bernd Helmle's repository