X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 17849D1DACB for ; Mon, 12 Apr 2004 19:36:23 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 16012-02 for ; Mon, 12 Apr 2004 19:36:22 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6E9DED1D06D for ; Mon, 12 Apr 2004 19:36:19 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3CMaAVM014552; Mon, 12 Apr 2004 18:36:10 -0400 (EDT) To: Robert Treat Cc: Stephan Szabo , Terry Hampton , pgsql-admin@postgresql.org Subject: Re: Location of a new column In-reply-to: <1081806272.22969.76.camel@camel> References: <40754755.2020603@limacorp.com> <20040408064736.E93611@megazone.bigpanda.com> <1081806272.22969.76.camel@camel> Comments: In-reply-to Robert Treat message dated "12 Apr 2004 17:44:31 -0400" Date: Mon, 12 Apr 2004 18:36:09 -0400 Message-ID: <14551.1081809369@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/192 X-Sequence-Number: 13165 Robert Treat writes: > On Thu, 2004-04-08 at 09:55, Stephan Szabo wrote: >> AFAIK, you can't using add column. It currently does no more than the >> SQL92/99 spec requires in that respect (which is put the column at the >> end). > IIRC this option is available in 7.5. No, there has been some discussion but no move to implement it. AFAIR there is no reasonable way to implement it without breaking apps that depend on the existing semantics of pg_attribute.attnum :-(. Check the pghackers archives if you want to know more. regards, tom lane