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

[Gerhard Häring]

--AhhlLboLdkugWU4S
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,
>=20
> I have a short question: How can I delete a COLUMN in PostGreSQL 7.1.x ?
> If I try :
>=20
> test=3D> alter table messages drop COLUMN betreff CASCADE;
>=20
> I get an error message like this ----|
> 						*|*
> 						 *
> ERROR:  ALTER TABLE / DROP COLUMN is not implemented
>=20
> 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
(http://postgresql.bnv-bamberg.de/docs/faq-english.htm)=20

Gerhard
--=20
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'=
)))

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

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

iD8DBQE7s7o7eyJldYarQ8ARAnRSAJ4+BxQRY7PSnuuaa53k+sNmjfhwoACeK+2t
FMSHKIbg+6cT41Wh5ZY7B08=
=xkxt
-----END PGP SIGNATURE-----

--AhhlLboLdkugWU4S--