diff options
| author | Neil Conway <neilc@samurai.com> | 2005-03-23 07:44:57 +0000 |
|---|---|---|
| committer | Neil Conway <neilc@samurai.com> | 2005-03-23 07:44:57 +0000 |
| commit | f30c76ce8de6a3d9e79367112a9287b576c9e9cd (patch) | |
| tree | 9017f983db33211276afd59bb3bd3fe89e340532 /doc/src | |
| parent | ac323044cf6afd43f17adb11d3241737a5e40d7b (diff) | |
| download | postgresql-f30c76ce8de6a3d9e79367112a9287b576c9e9cd.tar.gz postgresql-f30c76ce8de6a3d9e79367112a9287b576c9e9cd.zip | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/mvcc.sgml | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index 1aeec22b66c..5982c22bd33 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/mvcc.sgml,v 2.47 2005/02/26 18:37:17 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/mvcc.sgml,v 2.48 2005/03/23 07:44:56 neilc Exp $ --> <chapter id="mvcc"> @@ -677,9 +677,10 @@ SELECT SUM(value) FROM mytab WHERE class = 2; </para> <para> - This lock mode is not automatically acquired on user tables by any - <productname>PostgreSQL</productname> command. However it is - acquired on certain system catalogs in some operations. + Acquired by <command>CREATE TRIGGER</command> and + <command>ALTER TABLE ADD FOREIGN KEY</command>. This lock + mode can also be acquired on certain system catalogs in some + operations. </para> </listitem> </varlistentry> |