Postgres Pro
Downloads
Home   >   mailing lists

Thread: Locking a Table

Locking a Table

From
"Manohar.K (GM Systems)"
Date:
Hi
How to lock a table during transaction processing in PostgreSQL 7.0.2
K.Manoharan


-----Original Message-----
From: Shay Moreno [mailto:moreno@tdk.dk]
Sent: Thursday, April 26, 2001 6:07 PM
To: 'esavas@mac.com'; pgsql-novice@postgresql.org
Subject: Re: [NOVICE] DROP COLUMN ?


> Simple question, however could not find anything for it.

    Neither could I.  If you check the docs (go to
http://postgresql.org./, then to the users' lounge until you find
http://www.ca.postgresql.org/users-lounge/docs/7.1/reference/sql-altertable.
html at the Reference Manual) you will see the ALTER TABLE command doesn't
include a DROP COLUMN action.


> How can we drop a column from a table ?

    It seems we can't.




--
  _
 / \       Leandro Guimarães Faria Corcete Dutra        +55 (11) 3040 8913
 \ /       Amdocs Brasil Ltda at Tele Danmark                +45 3387 5214
  X      http://geocities.com./lgdutra/       mailto:leandrod@amdocs.com
 / \     Campanha fita ASCII                        mailto:moreno@tdk.dk

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Re: Locking a Table

From
ERIC Lawson - x52010
Date:
On Thu, 26 Apr 2001, Manohar.K (GM Systems) wrote:

> Hi
> How to lock a table during transaction processing in PostgreSQL 7.0.2
> K.Manoharan
>

See the SQL LOCK statement implementation, documented for 7.0 at

http://www.ca.postgresql.org/users-lounge/docs/7.0/user/sql-lock.htm

Eric Lawson

Re: Locking a Table

From
Shay Moreno
Date:
> How to lock a table during transaction processing in PostgreSQL 7.0.2

    In the reference manual at
http://postgresql.org/users-lounge/docs/7.1/reference/ you will find the
LOCK command,
http://postgresql.org/users-lounge/docs/7.1/reference/sql-lock.html.  Again
you can find this information thru the users' lounge at
http://postgresql.org./

    But usually you won't need to lock explicitly.  Locking will be done
automagically whenever you access any data.  The locks will be the minimum
necessary and sufficient to keep data integrity, and they will be release at
the end of the transaction: COMMIT, ROLLBACK or a program failure.



--
  _
 / \       Leandro Guimarães Faria Corcete Dutra        +55 (11) 3040 8913
 \ /       Amdocs Brasil Ltda at Tele Danmark                +45 3387 5214
  X      http://geocities.com./lgdutra/       mailto:leandrod@amdocs.com
 / \     Campanha fita ASCII                        mailto:moreno@tdk.dk