Skip site navigation (1) Skip section navigation (2)

Re: Pet Peeves?

From: John DeSoi <desoi(at)pgedit(dot)com>
To: pgsql-general List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pet Peeves?
Date: 2009-02-04 17:39:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Feb 3, 2009, at 3:41 PM, Peter Geoghegan wrote:

> What about postgreSQL's inability to re-order columns?
> Please don't point out that I shouldn't rely on things being in a
> certain order when I SELECT * FROM table. I'm well aware of that, I
> just generally have an aesthetic preference for a table's columns
> being in a certain order.

Somewhat related, it would be nice if columns had a unique identifier  
in the catalog rather than just a sequence number for the table. This  
would make it possible to distinguish between altering a column versus  
dropping/adding when comparing schemas or detecting DDL changes.

John DeSoi, Ph.D.

In response to


pgsql-general by date

Next:From: Karsten HilbertDate: 2009-02-04 17:48:17
Subject: Re: Pet Peeves?
Previous:From: Guy RouillierDate: 2009-02-04 17:37:31
Subject: Re: Pet Peeves?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group