Re: BUG #15940: json_populate_recordset fails with ERROR: recordtype has not been registered - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #15940: json_populate_recordset fails with ERROR: recordtype has not been registered
Date
Msg-id 20190809023505.GE3194@paquier.xyz
Whole thread Raw
In response to Re: BUG #15940: json_populate_recordset fails with ERROR: record typehas not been registered  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: BUG #15940: json_populate_recordset fails with ERROR: record typehas not been registered
Re: BUG #15940: json_populate_recordset fails with ERROR: record type has not been registered
List pgsql-bugs
On Tue, Aug 06, 2019 at 02:53:45PM -0500, Merlin Moncure wrote:
> For posterity I agree that OP was essentially exploiting undefined, or
> at least poorly defined, behavior.  For my money, I'd advise using
> this function for cases where you don't want to use an in place type,
> just a column list:

If I were to change something here, that would be this error string
exposed to the user.  With the current error, there is no real way
that the user knows what is wrong and why he/she should not do that.
Could it be possible to add some recommendation for example on top of
an error "cannot do that because blah"?
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Error in COPY command with files over 1GB
Next
From: "dsge94@outlook.com"
Date:
Subject: [HELP] Unable to initiate database cluster