Locking a Table

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