From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: proposal: ANSI SQL 2011 syntax for named parameters
Date: Thu, 07 Feb 2013 18:21:16 +0100
Message-ID: <m2ip64f3ar.fsf@2ndQuadrant.fr> (raw)
In-Reply-To: <14654.1360256790@sss.pgh.pa.us>
References: <CAFj8pRD82DOVWYqN5vQ-4OEZu3jK-B5mFDMXJ4kKqGTV0sGjOw@mail.gmail.com>
<CA+TgmobMsqAOUQDgs3i1ArVJ0yV8TC6L1jsuz53oeuJbDhnstQ@mail.gmail.com>
<CA+U5nMLWv-B3gwhDcgeq6E0t8b5cYAFzQyFAAehGSbDnSnRDbw@mail.gmail.com>
<CA+TgmoYpGdhPtF=spHo5eukVY=DvfahG42B1g0C+kr_+TnkGAA@mail.gmail.com>
<CA+U5nMLWB0u=FF7nhOdSy_W8qdTYGqkJR0zoRjHTdq=sxOBLHA@mail.gmail.com>
<CA+TgmoYXoKhtuUrcEA1Cft8HU2mmw1qhV6ceNktZi43-oc9q2Q@mail.gmail.com>
<CA+U5nMLPkXdHVz2tokYHhCVYrhPZcR8h8Vg4F7XOOLMsepOvRg@mail.gmail.com>
<CA+Tgmoa_Ut2oEvDf0n0_CBWkRTu9vX-YStrQq7AHF0Cy9XQgjg@mail.gmail.com>
<m2d2wcgk57.fsf@2ndQuadrant.fr>
<14654.1360256790@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Tom Lane <tgl@sss.pgh.pa.us> writes:
> If you're suggesting that we should back-patch hstore 1.1 into 9.1,
> there might not be a technical reason why we couldn't do it, but there
> are certainly project-policy reasons. Removing operators, or indeed
> changing any SQL interface at all, is exactly the kind of change we do
> not make in back branches.
For core itself, it makes perfect sense. For extensions, I wonder about
the upgrade path, and if we shouldn't leave some level fo choice to the
user. Shipping the ability to upgrade to hstore 1.1 into back branches
is not the same thing as upgrading our users.
>> To make that easier to maintain, there's a patch in the queue
>> implementing default_major_version so that we can ship hstore--1.0.sql
>> and hstore--1.0--1.1.sql and still have that command just works:
>> CREATE EXTENSION hstore VERSION '1.1';
>
> If the argument for this patch is only to support doing something like
> the above, I'd vote for rejecting it entirely.
This patch allows us to ship bug and security fixes in back branches
without having to maintain both the 1.1 and the 1.2 full scripts, as
PostgreSQL will now be able to install 1.1 and upgrade to 1.2 at CREATE
EXTENSION time.
So no, this patch is not made for something like forcing incompatible
changes down the throat of our users, it's made to make the life of
extension maintainers (core included) easier.
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: dimitri@2ndQuadrant.fr, tgl@sss.pgh.pa.us, robertmhaas@gmail.com, simon@2ndquadrant.com
Subject: Re: proposal: ANSI SQL 2011 syntax for named parameters
In-Reply-To: <m2ip64f3ar.fsf@2ndQuadrant.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox