Skip site navigation (1) Skip section navigation (2)

Re: JSON for PG 9.2

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Joey Adams <joeyadams3(dot)14159(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, "David E(dot) Wheeler" <david(at)kineticode(dot)com>, Claes Jakobsson <claes(at)surfar(dot)nu>, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Jan Urbański <wulczer(at)wulczer(dot)org>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>, Jan Wieck <janwieck(at)yahoo(dot)com>
Subject: Re: JSON for PG 9.2
Date: 2012-01-22 09:28:25
Message-ID: 4F1BD6B9.8010906@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

On 01/21/2012 11:40 PM, Jeff Janes wrote:
> On Sun, Jan 15, 2012 at 8:08 AM, Andrew Dunstan<andrew(at)dunslane(dot)net>  wrote:
>>
>> On 01/14/2012 03:06 PM, Andrew Dunstan wrote:
>>>
>>>
>>>
>>> OK, here's a patch that does both query_to_json and array_to_json, along
>>> with docs and regression tests. It include Robert's original patch, although
>>> I can produce a differential patch if required. It can also be pulled from
>>> <https://bitbucket.org/adunstan/pgdevel>
>>>
>>>
>>
>> Here's an update that adds row_to_json, plus a bit more cleanup.
> This is bit-rotted such that initdb fails
>
> creating template1 database in
> /tmp/bar/src/test/regress/./tmp_check/data/base/1 ... FATAL:  could
> not create unique index "pg_proc_oid_index"
> DETAIL:  Key (oid)=(3145) is duplicated.
>
> I bumped up those oids in the patch, and it passes make check once I
> figure out how to get the test run under UTF-8.  Is it supposed to
> pass under other encodings?  I can't tell from the rest of thread
> whether it supposed to pass in other encodings or not.
>

Yeah, regression tests generally are supposed to run in all encodings. 
Either we could knock out the offending test, or we could supply an 
alternative result file. If we do the latter, maybe we should modify the 
query slightly, so it reads

    SELECT 'getdatabaseencoding() = 'UTF8' as is_utf8, "\uaBcD"'::json;

cheers

andrew

In response to

Responses

pgsql-hackers by date

Next:From: Kohei KaiGaiDate: 2012-01-22 10:12:17
Subject: Re: [v9.2] LEAKPROOF attribute of FUNCTION (Re: [v9.2] Fix Leaky View Problem)
Previous:From: Jeff JanesDate: 2012-01-22 05:48:19
Subject: Re: Avoid FK validations for no-rewrite ALTER TABLE ALTER TYPE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group