Skip site navigation (1) Skip section navigation (2)

Locking a Table

From: "Manohar(dot)K (GM Systems)" <manohark(at)elgi(dot)jet(dot)co(dot)in>
To: "'Shay Moreno'" <moreno(at)tdk(dot)dk>, "'esavas(at)mac(dot)com'" <esavas(at)mac(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Locking a Table
Date: 2001-04-26 14:29:29
Message-ID: 73010348951BD511B09E00A0C9ED2F0F0F4C2B@ELGIMAIL (view raw or whole thread)
Lists: pgsql-novice
How to lock a table during transaction processing in PostgreSQL 7.0.2

-----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

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

	Neither could I.  If you check the docs (go to, then to the users' lounge until you find
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       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?


pgsql-novice by date

Next:From: Stephen M. FordDate: 2001-04-26 15:06:17
Subject: still having installing problems
Previous:From: Brett W. McCoyDate: 2001-04-26 13:09:53
Subject: Re: DROP COLUMN ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group