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

From Andrew Dunstan
Subject Re: pgsql: Use a new hstore extension version for added json functions.
Date
Msg-id 5248AD94.7070400@dunslane.net
Whole thread Raw
In response to Re: pgsql: Use a new hstore extension version for added json functions.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
On 09/29/2013 05:55 PM, Tom Lane wrote:
> 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.
>
>


Don't you think this is a bug fix?


cheers

andrew



pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Use a new hstore extension version for added json functions.
Next
From: Andrew Dunstan
Date:
Subject: pgsql: Fix makefile broken by hstore fix.