Re: no drop column?!

On Sun, 24 Mar 2002, Lucas Rockwell wrote:

> bavc=> alter table staff drop column date_created cascade;
> ERROR:  ALTER TABLE / DROP COLUMN is not implemented
>
> is this true???!!! i am using PostgreSQL 7.2.
>
> -lucas


Hello lucas

Yes, it is true -- with Pgsql 7.3, too.

There is a way to get around it, however, but requires creating temp
table, selecting, inserting and renaming back to original name. The php
user's guide explains this in detail.

But there is an easier way to do this, once you heve installed phpPgAdmin
(http://phppgadmin.sourceforge.net). phpPgAdmin automates the procedure to
create/select/insert/rename to one click.


--jq


--Jyry
C:-(    C:-/    C========8-O    C8-/    C:-(