]> granicus.if.org Git - postgresql/commit
Use a new hstore extension version for added json functions.
authorAndrew Dunstan <andrew@dunslane.net>
Sun, 29 Sep 2013 21:41:56 +0000 (17:41 -0400)
committerAndrew Dunstan <andrew@dunslane.net>
Sun, 29 Sep 2013 21:51:11 +0000 (17:51 -0400)
commit83e83aad562ce8a3e44335314a933528824dc521
tree20f7690d2037a60a9a3a6d4a4baf26a23b2bf6fc
parentf8110c5f66ad079e3dbc0b66bed06207c43643ef
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.
contrib/hstore/hstore--1.1--1.2.sql [new file with mode: 0644]
contrib/hstore/hstore--1.2.sql [moved from contrib/hstore/hstore--1.1.sql with 100% similarity]
contrib/hstore/hstore.control