| From: | neilc(at)svr1(dot)postgresql(dot)org (Neil Conway) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Adjust CREATE TRIGGER and ALTER TABLE ... |
| Date: | 2005-03-23 07:44:58 |
| Message-ID: | 20050323074458.372C353536@svr1.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Log Message:
-----------
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.
Modified Files:
--------------
pgsql/doc/src/sgml:
mvcc.sgml (r2.47 -> r2.48)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/mvcc.sgml.diff?r1=2.47&r2=2.48)
pgsql/src/backend/commands:
tablecmds.c (r1.148 -> r1.149)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c.diff?r1=1.148&r2=1.149)
trigger.c (r1.178 -> r1.179)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/trigger.c.diff?r1=1.178&r2=1.179)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | User Pjmodos | 2005-03-23 09:29:27 | docbot - docbot: Fixed 'tell somebody about something' query. |
| Previous Message | Bruce Momjian | 2005-03-23 06:11:57 | pgsql: Add: > o Add MOVE to PL/pgSQL |