From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | easteregg(at)verfriemelt(dot)org |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15999: jsonb_populate_record fails with array column |
Date: | 2019-09-10 14:38:01 |
Message-ID: | 29816.1568126281@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> given the following simplified table with one row inserted:
>> create table testa ( id serial, test text[] default
> '{"test","test2"}'::text[] );
>> insert into testa values (default);
> when we try to populate a record of testa type we run into trouble with
> postgres in version 9.6.15
>> select jsonb_populate_record(null::testa , to_jsonb(testa)) FROM testa;
> ERROR: 22P02: malformed array literal: "["test", "test2"]"
> DETAIL: "[" must introduce explicitly-specified array dimensions.
> LOCATION: array_in, arrayfuncs.c:269
Yeah, this is something we aren't going to risk changing pre-v10.
cf35346e8 is what fixed it, but that was a pretty massive rewrite
with bugs of its own, and IIRC it changed some other behaviors
that were less obviously bugs than the case you're complaining of.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-09-10 14:58:52 | Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND |
Previous Message | Tom Lane | 2019-09-10 13:59:30 | Re: BUG #15998: query to return a table column list gives error on a missing foreign data wrapper library |