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 flat)
Thread:
Lists: pgsql-novice
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

Responses

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-2014 The PostgreSQL Global Development Group