| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-committers(at)postgresql(dot)org |
| Subject: | Re: pgsql: Use a new hstore extension version for added json functions. |
| Date: | 2013-09-29 22:45:40 |
| Message-ID: | 5248AD94.7070400@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
On 09/29/2013 05:55 PM, Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2013-09-30 02:47:27 | pgsql: Fix makefile broken by hstore fix. |
| Previous Message | Tom Lane | 2013-09-29 21:55:45 | Re: pgsql: Use a new hstore extension version for added json functions. |