diff options
| author | Bruce Momjian <bruce@momjian.us> | 1999-06-03 19:18:00 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1999-06-03 19:18:00 +0000 |
| commit | e1ea7cc2e562b9e61528f37affada72a08a8adeb (patch) | |
| tree | a95f4ce251a6962f12bad7f2825750913a5a5267 /src | |
| parent | 4a077caa60b9c47e8a17dd5501c5dbd1e8a51165 (diff) | |
| download | postgresql-e1ea7cc2e562b9e61528f37affada72a08a8adeb.tar.gz postgresql-e1ea7cc2e562b9e61528f37affada72a08a8adeb.zip | |
Update lock sgml/man/psql help pages.
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/psql/psqlHelp.h | 5 | ||||
| -rw-r--r-- | src/man/lock.l | 10 |
2 files changed, 10 insertions, 5 deletions
diff --git a/src/bin/psql/psqlHelp.h b/src/bin/psql/psqlHelp.h index 6840786358f..507b0d54b4d 100644 --- a/src/bin/psql/psqlHelp.h +++ b/src/bin/psql/psqlHelp.h @@ -5,7 +5,7 @@ * * Copyright (c) 1994, Regents of the University of California * - * $Id: psqlHelp.h,v 1.66 1999/06/03 18:37:59 momjian Exp $ + * $Id: psqlHelp.h,v 1.67 1999/06/03 19:17:59 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -283,7 +283,8 @@ static struct _helpStruct QL_HELP[] = { {"lock", "exclusive lock a table inside a transaction", "\ -\tLOCK [TABLE] class_name;"}, +\tLOCK [TABLE] class_name \n\ +\t[[IN] [ROW|ACCESS] [SHARE|EXCLUSIVE] MODE];"}, {"move", "move an cursor position", "\ diff --git a/src/man/lock.l b/src/man/lock.l index 440e491b863..5f71a8a5d6a 100644 --- a/src/man/lock.l +++ b/src/man/lock.l @@ -1,16 +1,20 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/lock.l,v 1.5 1998/03/23 15:09:34 momjian Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/lock.l,v 1.6 1999/06/03 19:18:00 momjian Exp $ .TH FETCH SQL 01/23/93 PostgreSQL PostgreSQL .SH NAME lock - exclusive lock a table .SH SYNOPSIS .nf -\fBlock\fR [\fBtable\fR] classname +\fBlock\fR [\fBtable\fR] classname [[IN] [ROW|ACCESS] [SHARE|EXCLUSIVE] MODE] .fi .SH DESCRIPTION +By default, .BR lock -exclusive locks a table inside a transaction. The classic use for this +exclusive locks an entire table inside a transaction. +Various options allow shared access, or row-level locking control. +.PP +The classic use for this is the case where you want to \fBselect\fP some data, then update it inside a transaction. If you don't exclusive lock the table before the \fBselect\fP, some other user may also read the selected data, and try |