pgsql: Use a new hstore extension version for added json functions.

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Use a new hstore extension version for added json functions.
Date: 2013-09-29 21:50:13
Message-ID: E1VQOsX-0007Bm-13@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Use a new hstore extension version for added json functions.

This should have been done when the json functionality was added to
hstore in 9.3.0. To handle this correctly, the upgrade script therefore
uses conditional logic by using plpgsql in a DO statement to add the two
new functions and the new cast. If hstore_to_json_loose is detected as
already present and dependent on the hstore extension nothing is done.
This will require that the database be loaded with plpgsql.

People who have installed the earlier and spurious 1.1 version of hstore
will need to do:

ALTER EXTENSION hstore UPDATE;

to pick up the new functions properly.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/a18167510f4c385329697588ce5132cbf95779c3

Modified Files
--------------
contrib/hstore/hstore--1.1--1.2.sql | 47 +++
contrib/hstore/hstore--1.1.sql | 537 -----------------------------------
contrib/hstore/hstore--1.2.sql | 537 +++++++++++++++++++++++++++++++++++
contrib/hstore/hstore.control | 2 +-
4 files changed, 585 insertions(+), 538 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2013-09-29 21:51:40 pgsql: Use a new hstore extension version for added json functions.
Previous Message Andrew Dunstan 2013-09-29 21:33:45 pgsql: Backpatch pgxs vpath build and installation fixes.