Thread: Re: [ADMIN] no drop column?!

Re: [ADMIN] no drop column?!

From
"Dan Langille"
Date:
On 24 Mar 2002 at 20:34, 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.

No, it's lying to you.
-- 
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples



Re: [ADMIN] no drop column?!

From
"Serguei Mokhov"
Date:
----- Original Message ----- 
From: "Dan Langille" <dan@langille.org>
Sent: Sunday, March 24, 2002 11:39 PM

> > 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.
> 
> No, it's lying to you.

If it is, since when that feature was implemented???
I might have missed it then :)

-s


Re: [ADMIN] no drop column?!

From
"Dan Langille"
Date:
On 24 Mar 2002 at 23:41, Serguei Mokhov wrote:

> ----- Original Message ----- 
> From: "Dan Langille" <dan@langille.org>
> Sent: Sunday, March 24, 2002 11:39 PM
> 
> > > 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.
> > 
> > No, it's lying to you.
> 
> If it is, since when that feature was implemented???
> I might have missed it then :)

I was lying (actually, it was sarcasm) too.  The feature has not been 
implemented.
-- 
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples



Re: [ADMIN] no drop column?!

From
"Joel Burton"
Date:
> I was lying (actually, it was sarcasm) too.  The feature has not been
> implemented.

Some workaround ideas at
http://techdocs.postgresql.org/techdocs/updatingcolumns.php

Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant