Locking a Table - Mailing list pgsql-novice

From Manohar.K (GM Systems)
Subject Locking a Table
Date
Msg-id 73010348951BD511B09E00A0C9ED2F0F0F4C2B@ELGIMAIL
Whole thread Raw
Responses Re: Locking a Table  (ERIC Lawson - x52010 <eric@bioeng.washington.edu>)
List 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@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

pgsql-novice by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: DROP COLUMN ?
Next
From: "Stephen M. Ford"
Date:
Subject: still having installing problems