I just realized I never replied. This basically worked the only thing I couldn't get to work is to register the hstore binary send and receive functions with the hstore type. (As far as I can see there is no alter type set primitives or similar). However that doesn't matter for us as we don't use the binary protocol.
On Mon, Nov 19, 2012 at 3:22 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > Benedikt Grundmann <bgrundmann@janestreet.com> writes: >> What is the official guide line? > > You could try (1) run the 9.0 version of the hstore install script > and then (2) do the CREATE EXTENSION FROM UNPACKAGED bit. I'd > strongly recommend testing this procedure in a scratch copy of your > installation first, though. >
Thanks Tom. Due to <complicated-not-relevant-reasons> it might take a while for us to do so but if we do try this out I'll let the list know if it worked.