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 1hutBF-0004zh-2f for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Aug 2019 06:42:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hutBD-0002it-RH for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Aug 2019 06:42:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hutBD-0002im-HW for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2019 06:42:43 +0000 Received: from mail-pf1-x42e.google.com ([2607:f8b0:4864:20::42e]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hutBB-0007oE-Dp for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2019 06:42:43 +0000 Received: by mail-pf1-x42e.google.com with SMTP id y15so40958856pfn.5 for ; Mon, 05 Aug 2019 23:42:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:content-transfer-encoding:mime-version:subject:date:references :to:in-reply-to:message-id; bh=LPbwOsHFVLPbk7lQmOTzaPvKRON6KO26it3E49uWtKY=; b=IJjbL9cSqncQPyNgtrUNfdB6zbn0bMvYz0Ltlj1OSzXcg/sdr7ElU5aRCdCNYgvNmu +WxTRY8Qo78zFgY1N6y+Z6Gaoyyt5VNHeqWk5TdXLLagPk4FBY2SWPUblFp18jVM8k+S 4doTbMiyujeLYOIjpp4SpAvGbKz4M8aOIPbXaTKoNUIXQX4taIyUsDCpQ0tUztKSZ0Wo 6YuAuCcac7BJsRZa8FZE6fh6xyfM9emczDjuZ67qkQy8WT03E4VR9EfLlmOjIaApkDO9 s4sqAEFHdtwu5BUl4DRhfhwjMaM3qr1CHuVbIc0ozbDkdgQf7j5sZRlzZofzEXV7Fl82 /d+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version :subject:date:references:to:in-reply-to:message-id; bh=LPbwOsHFVLPbk7lQmOTzaPvKRON6KO26it3E49uWtKY=; b=J+bBa5jZZcRfebrwqfOC2SObENXqPJVjIXmOLwIabCngIPLqMfOsz6ljyYyIt4bEw7 VIzSJKw6Rw9JPscw6j4bXmfJoSCCZkVZMmr+TY80+DVn02/Am/WcOvr1TQhZwv4tBTvl KnHKXIIYg7TUhK4gtGNd94pUp7FUJiqlmfNMBDUHYGEdWj0VAWPN3cuM0INRwp8SteNO sDxvELVvLWBWNDlaFgWnaBnJ+ouBLuBk6bm4Q1j9JJD6zeelJ3PCw3bRFIJj6fiAH+GM gGj1Rrwq/KNJGx4li13Eu24BMpqXrAHp2dchAJkjGKSXGlWkLbUPfuAoT1DpiIIiVQDd viRg== X-Gm-Message-State: APjAAAWgBzG/z9B0JUSei4HNKCh4J7COviSL8IDaP3q4RX4URKo4JPKY C4fVf+/T8orcqU5W+noPbpCa9JXy5uM= X-Google-Smtp-Source: APXvYqx+JP2cn7jr4Q8/X/Y2+QuG2LD6PP6lTCTUgSe+zcX7cuK77LIwxWzwGz6hFOZvilcGW+GdJw== X-Received: by 2002:a63:f857:: with SMTP id v23mr1641176pgj.228.1565073758268; Mon, 05 Aug 2019 23:42:38 -0700 (PDT) Received: from [192.168.1.2] ([223.229.233.54]) by smtp.gmail.com with ESMTPSA id v14sm92555603pfm.164.2019.08.05.23.42.36 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 05 Aug 2019 23:42:37 -0700 (PDT) From: mathi joshi Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.1\)) Subject: Re: BUG #15940: json_populate_recordset fails with ERROR: record type has not been registered Date: Tue, 6 Aug 2019 12:12:31 +0530 References: <15940-2ab76dc58ffb85b6@postgresql.org> To: yarexeray@gmail.com, pgsql-bugs@lists.postgresql.org In-Reply-To: <15940-2ab76dc58ffb85b6@postgresql.org> Message-Id: <42100E9A-B20B-4A5D-8FFA-908AB4360EB0@gmail.com> X-Mailer: Apple Mail (2.3445.9.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > On 06-Aug-2019, at 12:11 PM, PG Bug reporting form = wrote: >=20 > The following bug has been logged on the website: >=20 > Bug reference: 15940 > Logged by: Jaroslav Sivy > Email address: yarexeray@gmail.com > PostgreSQL version: 11.2 > Operating system: freebsd > Description: =20 >=20 > 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 > ); >=20