Обсуждение: Re: [ADMIN] no drop column?!

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

----- 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

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

> 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