Horton

Re: inconsistent behaviour of json_to_record and friends with embedded json

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: Robert Vollmert <rob@vllmrt.net>, pgsql-bugs@lists.postgresql.org
Date: 2019-06-01T19:12:32Z
Lists: pgsql-bugs 
On Sat, Jun 01, 2019 at 03:06:27PM -0400, Jeff Janes wrote:
> This is caused by commit:
> 
> commit cf35346e813e5a1373f308d397bb0a8f3f21d530
> Author: Andrew Dunstan <andrew@dunslane.net>
> Date:   Thu Apr 6 22:11:21 2017 -0400
> 
>     Make json_populate_record and friends operate recursively
> 
> 
> As far as I can tell, this was not an intended change, so I agree it is
> probably a bug.

Thanks for digging into this one.  I have read through quickly at the
conference, and indeed it smells like a bug.  I'll try to look at
that asap, which is not before a couple of days unfortunately.
--
Michael

Commits

  1. Fix conversion of JSON strings to JSON output columns in json_to_record().

  2. Make json_populate_record and friends operate recursively