pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: yarexeray@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15940: json_populate_recordset fails with ERROR:  record type has not been registered
Date: Tue, 6 Aug 2019 16:32:09 +0900
Message-ID: <20190806073209.GI32256@paquier.xyz> (raw)
In-Reply-To: <15940-2ab76dc58ffb85b6@postgresql.org>
References: <15940-2ab76dc58ffb85b6@postgresql.org>

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

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (9+ messages)  latest in thread

Message-ID: <20190806073209.GI32256@paquier.xyz>
Permalink:  ../20190806073209.GI32256@paquier.xyz/
Also on:    postgresql.org/message-id/20190806073209.GI32256@paquier.xyz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: michael@paquier.xyz, yarexeray@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #15940: json_populate_recordset fails with ERROR:  record type has not been registered
  In-Reply-To: <20190806073209.GI32256@paquier.xyz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox