pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedno 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