Re: pgsql: Use a new hstore extension version for added json functions. - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Use a new hstore extension version for added json functions.
Date
Msg-id 42157.1380491745@sss.pgh.pa.us
Whole thread Raw
In response to pgsql: Use a new hstore extension version for added json functions.  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: pgsql: Use a new hstore extension version for added json functions.  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-committers
Andrew Dunstan <andrew@dunslane.net> writes:
> 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
> ------
> REL9_3_STABLE

Um  ... I think it's too late to do that sort of thing in 9.3.

            regards, tom lane


pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: pgsql: Use a new hstore extension version for added json functions.
Next
From: Andrew Dunstan
Date:
Subject: Re: pgsql: Use a new hstore extension version for added json functions.