diff options
| author | Bruce Momjian | 1998-01-27 15:35:30 +0000 |
|---|---|---|
| committer | Bruce Momjian | 1998-01-27 15:35:30 +0000 |
| commit | b4564a98fa6ba4c93f3d1fe49909eb170650a888 (patch) | |
| tree | 9afefa5f7e037afce45288dfef57380b4c358e14 /src/man/lock.l | |
| parent | f49d41353d237715ff4b0954d894a1e42617296c (diff) | |
Deadlock ceallnup.
(void) change for aix and hp compilers.
protocol cleanup.
Diffstat (limited to 'src/man/lock.l')
| -rw-r--r-- | src/man/lock.l | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/src/man/lock.l b/src/man/lock.l index 8882cf15fb7..0f2060dd5e1 100644 --- a/src/man/lock.l +++ b/src/man/lock.l @@ -1,6 +1,6 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/lock.l,v 1.1 1998/01/23 06:01:36 momjian Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/lock.l,v 1.2 1998/01/27 15:35:30 momjian Exp $ .TH FETCH SQL 01/23/93 PostgreSQL PostgreSQL .SH NAME lock - exclusive lock a table @@ -17,6 +17,12 @@ inside a transaction. If you don't exclusive lock the table before the and do their own \fBupdate\fP, causing a deadlock while you both wait for the other to release the \fBselect\fP-induced shared lock so you can get an exclusive lock to do the \fBupdate.\fP +.PP +Another example of deadlock is where one user locks one table, and +another user locks a second table. While both keep their existing +locks, the first user tries to lock the second user's table, and the +second user tries to lock the first user's table. Both users deadlock +waiting for the tables to become available. .SH EXAMPLES .nf -- |