Adjust CREATE TRIGGER and ALTER TABLE ... ADD FOREIGN KEY to acquire
Neil Conway <neilc@samurai.com>
Adjust CREATE TRIGGER and ALTER TABLE ... ADD FOREIGN KEY to acquire ExclusiveLock rather than AccessExclusiveLock. This will allow concurrent SELECT queries to proceed on the table. Per discussion with Andrew at SuperNews.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/mvcc.sgml | modified | +5 −4 |
| src/backend/commands/tablecmds.c | modified | +7 −7 |
| src/backend/commands/trigger.c | modified | +9 −2 |