[Zope-DB] Delete a column in a table with PostGreSQL 7.1.x

Gerhard Häring gerhard@bigfoot.de
Fri, 28 Sep 2001 01:46:04 +0200

Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Sep 27, 2001 at 10:23:50AM +0200, Florian Schuler wrote:
> Hello list,
> I have a short question: How can I delete a COLUMN in PostGreSQL 7.1.x ?
> If I try :
> test=3D> alter table messages drop COLUMN betreff CASCADE;
> I get an error message like this ----|
> 						*|*
> 						 *
> ERROR:  ALTER TABLE / DROP COLUMN is not implemented
> I am shocked. How can I do that ??

I think the error message is pretty clear :-)

But there is a workaround, see question 4.5 in the FAQ

mail:   gerhard <at> bigfoot <dot> de       registered Linux user #64239
web:    http://www.cs.fhm.edu/~ifw00065/    OpenPGP public key id 86AB43C0
public key fingerprint: DEC1 1D02 5743 1159 CD20  A4B6 7B22 6575 86AB 43C0
reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b'=

Content-Type: application/pgp-signature
Content-Disposition: inline

Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org