Re: jsonb and nested hstore

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, obartunov(at)gmail(dot)com, Peter Geoghegan <pg(at)heroku(dot)com>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Christophe Pettus <xof(at)thebuild(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: jsonb and nested hstore
Date: 2014-03-06 20:58:09
Message-ID: CA+mi_8Y-yBdWVXyy=VU0z9zLY=4MLoeqAj1tEJGOTO-enjs9SA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 6, 2014 at 6:54 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>
> The actual storage upgrade of hstore-->hstore2 is fairly painless from
> the user perspective; they don't have to do anything. The problem is
> that the input/output strings are different, something which I didn't
> think to check for (and Peter did), and which will break applications
> relying on Hstore, since the drivers which support Hstore (like
> psycopg2) rely on string-parsing to convert it. I haven't
> regression-tested hstore2 against psycopg2 since I don't have a good
> test, but that would be a useful thing to do.

Hello, psycopg developer here. Not following the entire thread as it's
quite articulated and not of my direct interest (nor comprehension).
But if you throw at me a few test cases I can make sure psycopg can
parse them much before hstore2 is released.

FYI I have a trigger that highlights me the -hackers messages
mentioning psycopg, so just mentioning it is enough for me to take a
better look. But if you want a more active collaboration just ask.

Thank you,

-- Daniele

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2014-03-06 21:10:48 Re: jsonb and nested hstore
Previous Message Jeff Janes 2014-03-06 20:44:54 Re: GSoC on WAL-logging hash indexes