Re: full featured alter table?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tino Wildenhain <tino(at)wildenhain(dot)de>
Cc: Ernest E Vogelsinger <ernest(at)vogelsinger(dot)at>, "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, Sven Köhler <skoehler(at)upb(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: full featured alter table?
Date: 2003-06-15 21:52:01
Message-ID: 2220.1055713921@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tino Wildenhain <tino(at)wildenhain(dot)de> writes:
> why not just order the output columns in alphabetical order?

Because it would violate the SQL spec. While the spec does not propose
any ALTER TABLE command that would let one rearrange the column order,
it is perfectly clear about the semantics of "SELECT *" and "INSERT"
when one has only done CREATE TABLE and ALTER TABLE ADD COLUMN. We do
not get to invent our own behavior there.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message nolan 2003-06-15 22:05:32 Optimizer failure on update w/integer column
Previous Message Bruno BAGUETTE 2003-06-15 21:30:45 RE : full featured alter table?