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(at)tdk(dot)dk]
Sent: Thursday, April 26, 2001 6:07 PM
To: 'esavas(at)mac(dot)com'; pgsql-novice(at)postgresql(dot)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(at)amdocs(dot)com
/ \ Campanha fita ASCII mailto:moreno(at)tdk(dot)dk

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

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