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 по дате отправления