pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: 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 17:32:04 +0100
Message-ID: <m2d2wcgk57.fsf@2ndQuadrant.fr> (raw)
In-Reply-To: <CA+Tgmoa_Ut2oEvDf0n0_CBWkRTu9vX-YStrQq7AHF0Cy9XQgjg@mail.gmail.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

Robert Haas <robertmhaas@gmail.com> writes:
> $ Right now there is one and only one release in
> $ the field that contains hstore 1.1.  If we go ahead and prohibit => as
> $ an operator name now, we're going to require everyone who is on 9.1
> $ and uses hstore and wants to get to 9.3 to either (a) first upgrade to
> $ 9.2, then update hstore, then upgrade to 9.3; or (b) dig the
> $ hstore-1.1 update out of a future release, apply it to an earlier
> $ release on which it did not ship, and then upgrade.
>
> I don't know what to add to that.

There's no technical reason that I'm aware of for hstore 1.1 not to
support all our maintained releases at the same time. That's exactly how
we do it with non-core extensions, by the way.

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';

That support is going to ease a lot dump and support of Extensions
installed from a Template, too, so much so that I would really like to
get some reviewing about that before sending the full patch.

We've been talking about "in-core extensions" as opposed to contribs for
a while now, I think this is another angle to see things through. We
could actually maintain proper extensions the proper way.

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



view thread (22+ messages)  latest in thread

Message-ID: <m2d2wcgk57.fsf@2ndQuadrant.fr>
Permalink:  ../m2d2wcgk57.fsf@2ndQuadrant.fr/
Also on:    postgresql.org/message-id/m2d2wcgk57.fsf@2ndQuadrant.fr

 · 

reply

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, robertmhaas@gmail.com, simon@2ndquadrant.com
  Subject: Re: proposal: ANSI SQL 2011 syntax for named parameters
  In-Reply-To: <m2d2wcgk57.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