Re: BUG #15999: jsonb_populate_record fails with array column

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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

In response to

Browse pgsql-bugs by date

  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