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