an already existing alter table drop column ?!?!?! 
Author Message
 an already existing alter table drop column ?!?!?!
While looking through the code I found an already existing alter table drop
column in src/backend/parser/gram.y.  However, when I try to run it in psql
it comes back with a not implemented.  Was the left hand not talking to the
right hand when this was coded or is there more to this?

Geoff

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Wed, 10 Mar 2004 01:10:24 GMT
 an already existing alter table drop column ?!?!?!

Quote:

> While looking through the code I found an already existing alter table drop
> column in src/backend/parser/gram.y.  However, when I try to run it in psql
> it comes back with a not implemented.  Was the left hand not talking to the
> right hand when this was coded or is there more to this?

IIRC, it was not enabled pending further discussion of the behavior.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Wed, 10 Mar 2004 01:34:29 GMT
 an already existing alter table drop column ?!?!?!

Quote:


> > While looking through the code I found an already existing alter table drop
> > column in src/backend/parser/gram.y.  However, when I try to run it in psql
> > it comes back with a not implemented.  Was the left hand not talking to the
> > right hand when this was coded or is there more to this?

> IIRC, it was not enabled pending further discussion of the behavior.

As to 'DROP COLUMN', I neglected to remove _DROP_COLUMN_HACK__
stuff which has no meaing now sorry. I would remove it after
the 7.2 release.

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Fri, 12 Mar 2004 11:18:48 GMT
 an already existing alter table drop column ?!?!?!
Does this mean that the code is or isn't usable?

Geoff

Quote:
-----Original Message-----

Sent: Sunday, September 23, 2001 11:02 PM
To: Stephan Szabo


Subject: Re: [HACKERS] an already existing alter table drop column ?!?!?!



> > While looking through the code I found an already existing alter table
drop
> > column in src/backend/parser/gram.y.  However, when I try to run it in
psql
> > it comes back with a not implemented.  Was the left hand not talking to
the
> > right hand when this was coded or is there more to this?

> IIRC, it was not enabled pending further discussion of the behavior.

As to 'DROP COLUMN', I neglected to remove _DROP_COLUMN_HACK__
stuff which has no meaing now sorry. I would remove it after
the 7.2 release.

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command




Sat, 13 Mar 2004 00:33:14 GMT
 an already existing alter table drop column ?!?!?!

isn't

Quote:

> Does this mean that the code is or isn't usable?

> Geoff

> -----Original Message-----

> Sent: Sunday, September 23, 2001 11:02 PM
> To: Stephan Szabo

> Subject: Re: [HACKERS] an already existing alter table drop column ?!?!?!



> > > While looking through the code I found an already existing alter table
> drop
> > > column in src/backend/parser/gram.y.  However, when I try to run it in
> psql
> > > it comes back with a not implemented.  Was the left hand not talking to
> the
> > > right hand when this was coded or is there more to this?

> > IIRC, it was not enabled pending further discussion of the behavior.

> As to 'DROP COLUMN', I neglected to remove _DROP_COLUMN_HACK__
> stuff which has no meaing now sorry. I would remove it after
> the 7.2 release.

> regards,
> Hiroshi Inoue

> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command


---------------------------(end of broadcast)---------------------------



Sat, 13 Mar 2004 01:14:26 GMT
 an already existing alter table drop column ?!?!?!
damn.  Is there a usable version being worked around? If so, how long before
it is available?

Geoff

Quote:
-----Original Message-----

Sent: Monday, September 24, 2001 1:14 PM
To: Gowey, Geoffrey


Subject: Re: [HACKERS] an already existing alter table drop column
?!?!?!

isn't

---------------------------(end of broadcast)---------------------------




Sat, 13 Mar 2004 01:20:51 GMT
 an already existing alter table drop column ?!?!?!

Quote:

> damn.  Is there a usable version being worked around? If so, how long before
> it is available?

too many dissending opinions on how it should (and shouldn't) be done ...
the one that was put in pre-maturely needed 2x the disk space to do ... so
if you had a multi-gig table, you had to have enough free space to store a
second copy in order to remove a column ...

there was a bunch of us that felt that it could be done better using a
'flag' on the column so that it was hidden ... and some that thought ...
etc, etc ...

Quote:
> > Geoff

> -----Original Message-----

> Sent: Monday, September 24, 2001 1:14 PM
> To: Gowey, Geoffrey

> Subject: Re: [HACKERS] an already existing alter table drop column
> ?!?!?!

> isn't

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly


Sat, 13 Mar 2004 01:29:02 GMT
 an already existing alter table drop column ?!?!?!
I do like the flag idea as a temporary patch until a fully workable solution
is available.  Just run a delete on the column and then flag it so it takes
up no space and is hidden.  By doing this now a more perfect solution can be
found later.  

Geoff

Quote:
-----Original Message-----

Sent: Monday, September 24, 2001 1:28 PM
To: Gowey, Geoffrey


Subject: RE: [HACKERS] an already existing alter table drop column
?!?!?!


> damn.  Is there a usable version being worked around? If so, how long
before
> it is available?

too many dissending opinions on how it should (and shouldn't) be done ...
the one that was put in pre-maturely needed 2x the disk space to do ... so
if you had a multi-gig table, you had to have enough free space to store a
second copy in order to remove a column ...

there was a bunch of us that felt that it could be done better using a
'flag' on the column so that it was hidden ... and some that thought ...
etc, etc ...

> > Geoff

> -----Original Message-----

> Sent: Monday, September 24, 2001 1:14 PM
> To: Gowey, Geoffrey

> Subject: Re: [HACKERS] an already existing alter table drop column
> ?!?!?!

> isn't

---------------------------(end of broadcast)---------------------------




Sat, 13 Mar 2004 01:37:25 GMT
 an already existing alter table drop column ?!?!?!
Also, rename the column to something else so a new one can be created in
it's place with the same name.  Do columns have their own oid's?  If so this
plus some random chars could be the new name.

Geoff

Quote:
-----Original Message-----
From: Gowey, Geoffrey
Sent: Monday, September 24, 2001 1:35 PM
To: 'Marc G. Fournier'; Gowey, Geoffrey


Subject: RE: [HACKERS] an already existing alter table drop column
?!?!?!

I do like the flag idea as a temporary patch until a fully workable solution
is available.  Just run a delete on the column and then flag it so it takes
up no space and is hidden.  By doing this now a more perfect solution can be
found later.  

Geoff

-----Original Message-----

Sent: Monday, September 24, 2001 1:28 PM
To: Gowey, Geoffrey

Subject: RE: [HACKERS] an already existing alter table drop column
?!?!?!


> damn.  Is there a usable version being worked around? If so, how long
before
> it is available?

too many dissending opinions on how it should (and shouldn't) be done ...
the one that was put in pre-maturely needed 2x the disk space to do ... so
if you had a multi-gig table, you had to have enough free space to store a
second copy in order to remove a column ...

there was a bunch of us that felt that it could be done better using a
'flag' on the column so that it was hidden ... and some that thought ...
etc, etc ...

> > Geoff

> -----Original Message-----

> Sent: Monday, September 24, 2001 1:14 PM
> To: Gowey, Geoffrey

> Subject: Re: [HACKERS] an already existing alter table drop column
> ?!?!?!

> isn't

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Sat, 13 Mar 2004 01:51:37 GMT
 
 [ 9 post ] 

 Relevant Pages 

1. alter identity column in an existing table

2. ALTER TABLE - Change existing Column Size?

3. Using alter table to drop columns

4. Alter table drop column ?!?

5. alter table drop column status

6. Alter table Modify Column length, Drop Identity

7. commit during alter table drop column

8. alter table drop column ...

9. Help SP: for ALTER TABLE....DROP COLUMN

10. Help SP: ALTER TABLE...DROP COLUMN

11. Alter table drop column and background vacuum?

12. Alter Table Drop Column problem


 
Powered by phpBB® Forum Software