Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hutxG-0006po-Nn for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Aug 2019 07:32:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hutxE-0004jM-AC for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Aug 2019 07:32:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hutxC-0004ip-KN for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2019 07:32:20 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1hutx9-0007YK-N5 for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2019 07:32:17 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 374C1522; Tue, 6 Aug 2019 03:32:14 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Tue, 06 Aug 2019 03:32:14 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=ZgtI3BnjbcYVizWOEW69K37cuTz xsQ3WuaHOLzE6+Dc=; b=BMXkQ4289KGzLwWZbsSv5z29vQY2tx4k1BZk0bkRm1r W2KhqdZp05p4n80G+AAyD7u2Oq9NEDy4s8vu4Ruk5R5xGsB+F0Iiq8t/xpsOVkjk IdSRgAIick43WJJtJ8K3ZfK3jc6QicpyVRhqFVcEG7O2hqviJSBhgAP31gd9G1KI UuNcgqbacW+sPJNNtH7w+HaVjr3XB4Y5RGCwQmdvWuESmImH7vOzAV0Kv2J8G1A0 xp50rL6635/WKj0I0/qy72UqBnPrA/1x2+PynHkBlXE+0fJcL/USJXjGMYKCTLYY 4m6lkufywYCUEBi7mBDZwjYZY9CqsPBlJa+cn0IGnmw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=ZgtI3B njbcYVizWOEW69K37cuTzxsQ3WuaHOLzE6+Dc=; b=yqMO+p4M2qowP6kfWVslPr n/oK1SAJvaMBB0+TtINnVnMIHCXNg2xmd/Yb/IXAM2QoyEhV9HSuC8eC4ksvebmE Kz0yuKcJwjMAvhwGrZ/iNJF2dSapobIFvUMd80ht8Un+wHDLNvFeWI4cu/hwVYSU ctVNbCc+VGvYXRE71UK1coJAEvEwVtrb4JEP8FEyfVoQyfiPT2I2H7i2jistqJBS GZmldDClodM67Wzx4uEzG++aTaAl3Nj+kbfvru/HC2Ew+flIc+5ZSOnyasryPtg6 zPl+hh3d3hX/i57hZIHOgbgkPUD79xYx6sHr9Sqa1fJBfhJFeI2//GzkQgZjVfKA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduvddruddtledguddvfecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdefhedmnecujfgurhepff fhvffukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghq uhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecukfhppeduuddurd dutddvrddukedtrddukeehnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghl sehprghquhhivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 5058080068; Tue, 6 Aug 2019 03:32:12 -0400 (EDT) Date: Tue, 6 Aug 2019 16:32:09 +0900 From: Michael Paquier To: yarexeray@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15940: json_populate_recordset fails with ERROR: record type has not been registered Message-ID: <20190806073209.GI32256@paquier.xyz> References: <15940-2ab76dc58ffb85b6@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="cN519qCC4CN1mUcX" Content-Disposition: inline In-Reply-To: <15940-2ab76dc58ffb85b6@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --cN519qCC4CN1mUcX Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Aug 06, 2019 at 06:41:34AM +0000, PG Bug reporting form wrote: > Following query works fine in previous freebsd versions >=20 > SELECT > id_item =20 > 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 date: Thu, 26 Oct 2017 13:47:45 -0400 Support domains over composite types. -- Michael --cN519qCC4CN1mUcX Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl1JLPkACgkQnvQgOdby QH1jSw/8DpnCh+7eqzsST5eOq1fdEhuKqHzQP+FUlYHZHzwrZExMAnC7ofshr4+2 dWRLY0NIbRwuqQ6RNMI8KdQefTa7Kk4Go0v+gLegFlOjdtIl0augbo8jnIu2G+NF zNaUTk4Ge5KCHalDyIHMyRpX2iZGNWKkPxLUgWYIpMPLBmUqh5U3yZPp2SBWrA1k 7I5jUzlhnEjaLPn1t/8yYqwktPGay9PSNoRe7Pv8yExj0WO5b+mATVomZDhcYYQ8 6yuda9uSVbjmG/2ICH6ccF5QZA+6MZuPm4X1xEFc2rUTMxn7A1/qJTuG4mhug4zI SUiJpUt8kecfkyq+c1asozLNwe2qx1zYe73+ihHy3fKFNDS0660BlVWW25q+88U6 peRjZsIc8vGHcUHLdr0iGdzo51uvkiXe5fRJKgD/izNm7lMek0RT0U3m3llSIydz I9Av2Qp8KjRXQLSwu5fRHEmo8JcndTLi5T0yVJ2B56awav8vI6q3nGTiqgi/ZuH8 E+Ox7SoR3uLs+3suiuzMCCa504SyIinIkXviAI6m+xoFRPJUwoZBOw7Y6ye7MDsf q5zdWmvr/K8+rSxhmIfDDcSTohJ8S05/HEZaU9/7c5FTGx4P9Q1/NVebrVjRm6iU 86yHkSG2FdbojSYVLEwry7M5XOs+Vc7Yx2AkQ7R5rZUr1Q7B9JA= =M4W4 -----END PGP SIGNATURE----- --cN519qCC4CN1mUcX--