Alter column position
I'm curious, is there any latest word on this?
(Note that I've read fully the link http://wiki.postgresql.org/wiki/Alter_column_position as well as all links stemming from it).
I could go digging through the latest source code, or the mailing list Archives, but I get the feeling I'll really only get the latest info by asking here.
Yesterday I forgot to put an auto-incremting "id" column for the usual pkey on a table I was creating (I was just really sleepy). So I did an ALTER TABLE and added to the end. But then seeing the "id" column at the end of the column list in psql and PgAdminIII just really messed with the aesthetic sensibilities in my brain.
I know, I can do the work-arounds in the wiki, and in this case I just re-created the table since it was fresh and had no data, but I would still really love to be able to properly re-order things.
I would love to do it myself, but I'm barely even proficient with writing front-end SQL, let alone working on the backend of a complicated server implementation.
Dunno what good this email will do,
just felt like writing a bit :-)
-Patrick
On Sat, May 22, 2010 at 09:34:50AM -0400, Patrick Rutkowski wrote:
I'm curious, is there any latest word on this?
(Note that I've read fully the link
http://wiki.postgresql.org/wiki/Alter_column_position as well as all
links stemming from it).
No one's working on it, to my knowledge. While the "SELECT *" case
doesn't interest me too much, it would be part of the infrastructure
needed for PostgreSQL to optimize storage by placing all fixed-length
columns before any variable-length ones.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
Hmm, interesting.
Though I do see how the performance bumps could be useful, I would still bet that the huge majority of users who utters the words "damn, I wish I could re-order columns" are just talking about the visual order in psql(1) or PgAdminIII.
On May 22, 2010, at 10:49 AM, David Fetter wrote:
Show quoted text
On Sat, May 22, 2010 at 09:34:50AM -0400, Patrick Rutkowski wrote:
I'm curious, is there any latest word on this?
(Note that I've read fully the link
http://wiki.postgresql.org/wiki/Alter_column_position as well as all
links stemming from it).No one's working on it, to my knowledge. While the "SELECT *" case
doesn't interest me too much, it would be part of the infrastructure
needed for PostgreSQL to optimize storage by placing all fixed-length
columns before any variable-length ones.Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.icsRemember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
On Sat, May 22, 2010 at 11:01 AM, Patrick Rutkowski <rutski89@gmail.com> wrote:
Though I do see how the performance bumps could be useful, I would still bet that the huge majority of users who utters the words "damn, I wish I could re-order columns" are just talking about the visual order in psql(1) or PgAdminIII.
make a view :-)
merlin