Re: updated hstore patch - Mailing list pgsql-hackers

From Tom Lane
Subject Re: updated hstore patch
Date
Msg-id 22438.1253461380@sss.pgh.pa.us
Whole thread Raw
In response to Re: updated hstore patch  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Responses Re: updated hstore patch
List pgsql-hackers
Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> Andrew Gierth wrote:
>> - what to do when installing the new version's .sql into an existing db;
>> the send/recv support and some of the index support doesn't get installed
>> if the hstore type and opclasses already exist. In the case of an upgrade
>> (or a dump/restore from an earlier version) it would be nice to make all
>> the functionality available; but there's no CREATE OR REPLACE for types
>> or operator classes.

> If the perfect solution is too complex, I'd also kinda hope this isn't a
> show-stopper for this patch, but rather a TODO for the future modules feature.

Yeah, this is a long-standing generic issue, and not really hstore's
problem to fix.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Anonymous code blocks
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: GRANT ON ALL IN schema