pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
no drop column?!
6+ messages / 5 participants
[nested] [flat]

* no drop column?!
@ 2002-03-25 04:34  Lucas Rockwell <lr@socrates.Berkeley.EDU>
  0 siblings, 2 replies; 6+ messages in thread

From: Lucas Rockwell @ 2002-03-25 04:34 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org

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

------------------------
Lucas Rockwell
UAS Systems Group
510.642.6465
lr@socrates.berkeley.edu
------------------------






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [ADMIN] no drop column?!
@ 2002-03-25 04:39  Dan Langille <dan@langille.org>
  parent: Lucas Rockwell <lr@socrates.Berkeley.EDU>
  1 sibling, 1 reply; 6+ messages in thread

From: Dan Langille @ 2002-03-25 04:39 UTC (permalink / raw)
  To: Lucas Rockwell <lr@socrates.Berkeley.EDU>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [ADMIN] no drop column?!
@ 2002-03-25 04:41  Serguei Mokhov <sa_mokho@alcor.concordia.ca>
  parent: Dan Langille <dan@langille.org>
  0 siblings, 1 reply; 6+ messages in thread

From: Serguei Mokhov @ 2002-03-25 04:41 UTC (permalink / raw)
  To: dan@langille.org; Lucas Rockwell <lr@socrates.Berkeley.EDU>; +Cc: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [ADMIN] no drop column?!
@ 2002-03-25 04:56  Dan Langille <dan@langille.org>
  parent: Serguei Mokhov <sa_mokho@alcor.concordia.ca>
  0 siblings, 1 reply; 6+ messages in thread

From: Dan Langille @ 2002-03-25 04:56 UTC (permalink / raw)
  To: Serguei Mokhov <sa_mokho@alcor.concordia.ca>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: no drop column?!
@ 2002-03-25 07:11  Jyry Kuukkanen <jyry@neutech.fi>
  parent: Lucas Rockwell <lr@socrates.Berkeley.EDU>
  1 sibling, 0 replies; 6+ messages in thread

From: Jyry Kuukkanen @ 2002-03-25 07:11 UTC (permalink / raw)
  To: Lucas Rockwell <lr@socrates.Berkeley.EDU>; +Cc: pgsql-admin@postgresql.org

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




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [ADMIN] no drop column?!
@ 2002-03-25 15:32  Joel Burton <joel@joelburton.com>
  parent: Dan Langille <dan@langille.org>
  0 siblings, 0 replies; 6+ messages in thread

From: Joel Burton @ 2002-03-25 15:32 UTC (permalink / raw)
  To: dan@langille.org; Serguei Mokhov <sa_mokho@alcor.concordia.ca>; +Cc: pgsql-sql

> 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




^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2002-03-25 15:32 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-25 04:34 no drop column?! Lucas Rockwell <lr@socrates.Berkeley.EDU>
2002-03-25 04:39 ` Dan Langille <dan@langille.org>
2002-03-25 04:41   ` Serguei Mokhov <sa_mokho@alcor.concordia.ca>
2002-03-25 04:56     ` Dan Langille <dan@langille.org>
2002-03-25 15:32       ` Joel Burton <joel@joelburton.com>
2002-03-25 07:11 ` Jyry Kuukkanen <jyry@neutech.fi>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox