Re: BUG #15514: process fails on jsonb_populate_recordset query. see simple example below - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15514: process fails on jsonb_populate_recordset query. see simple example below
Date
Msg-id 6764.1542918080@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #15514: process fails on jsonb_populate_recordset query. seesimple example below  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Responses Re: BUG #15514: process fails on jsonb_populate_recordset query. seesimple example below  (Haribabu Kommi <kommi.haribabu@gmail.com>)
List pgsql-bugs
Haribabu Kommi <kommi.haribabu@gmail.com> writes:
> Accessing of NULL pointer leads to crash. Attached quick simple patch fixes
> the problem.

While that stops the crash, it doesn't do what we want, which is to
return a valid tupdesc.  Without that you get "set-valued function called
in context that cannot accept a set" errors.  I think the right fix is
to force a call of update_cached_tupdesc so that there always is a
tupdesc to copy.

            regards, tom lane


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15517: JSONB_BUILD_ARRAY and JSON_BUILD_ARRAY omit XMLDeclaration (if present) from XML colums
Next
From: Nurmurat Gurbanliyew
Date:
Subject: PostgreSQL v11 offline (portable) version libwinpthread-1.dll error