Re: jsonb and nested hstore

Поиск
Список
Период
Сортировка
Искать
От
Josh Berkus
Тема
Re: jsonb and nested hstore
Дата
Msg-id
53191EC1.7070407@agliodbs.com
Список
Дерево обсуждения
jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Alvaro Herrera <alvherre@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Alvaro Herrera <alvherre@2ndquadrant.com>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore "Erik Rijkers" <er@xs4all.nl>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Hannu Krosing <hannu@2ndQuadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Hannu Krosing <hannu@2ndQuadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Alvaro Herrera <alvherre@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Thom Brown <thom@linux.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Thom Brown <thom@linux.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
Re: jsonb and nested hstore Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore "Erik Rijkers" <er@xs4all.nl>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Alvaro Herrera <alvherre@2ndquadrant.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Tomas Vondra <tv@fuzzy.cz>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
adt Makefile, was Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: adt Makefile, was Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: adt Makefile, was Re: jsonb and nested hstore Alvaro Herrera <alvherre@2ndquadrant.com>
Re: adt Makefile, was Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: adt Makefile, was Re: jsonb and nested hstore Michael Paquier <michael.paquier@gmail.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Heikki Linnakangas <hlinnakangas@vmware.com>
Re: jsonb and nested hstore - small docpatch "Erik Rijkers" <er@xs4all.nl>
Re: jsonb and nested hstore - small docpatch "Erik Rijkers" <er@xs4all.nl>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Hannu Krosing <hannu@2ndQuadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
On 03/06/2014 12:58 PM, Daniele Varrazzo wrote:
> On Thu, Mar 6, 2014 at 6:54 PM, Josh Berkus  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.

Looks like that won't be necessary, Daniele.  But thanks for speaking up!

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


В списке pgsql-hackers по дате отправления
От: Greg Stark
Дата:
От: Kouhei Kaigai
Дата:
FAQ