Horton

Re: BUG #15940: json_populate_recordset fails with ERROR: record type has not been registered

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: yarexeray@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2019-08-06T07:32:09Z
Lists: pgsql-bugs 
On Tue, Aug 06, 2019 at 06:41:34AM +0000, PG Bug reporting form wrote:
> Following query works fine in previous freebsd versions
> 
> SELECT
> 	id_item          
> FROM json_populate_recordset(null::record, '[{"id_item":776}]')
> AS
> (
> 	id_item int
> );

This visibly is a regression between 11 and 10, and one bisect later
here is the culprit:
commit: 37a795a60b4f4b1def11c615525ec5e0e9449e05
author: Tom Lane <tgl@sss.pgh.pa.us>
date: Thu, 26 Oct 2017 13:47:45 -0400
Support domains over composite types.
--
Michael

Commits

  1. Restore json{b}_populate_record{set}'s ability to take type info from AS.

  2. Support domains over composite types.