Re: Please provide examples of rows from
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
Guyren Howe <guyren@gmail.com>,
Pg Docs <pgsql-docs@lists.postgresql.org>
Date: 2020-09-20T18:09:13Z
Lists: pgsql-docs
Attachments
- improve-message-for-unwanted-coldeflist.patch (text/x-diff) patch
I wrote: > Yeah, this error message needs some help. With a function having > multiple OUT parameters, the prorettype is indeed "record", but > the specific record type is implied by the OUT parameters so you > do not need to (and can't) specify it in the query. > The point of the AS feature is to allow specifying the concrete > record type for record-returning functions that don't have a > predefined result record type, like dblink(). > I think this error text was written before we had multiple OUT > parameters, so it was okay at the time; but now it needs to be > more precise. Concretely, perhaps like the attached. I was unsurprised to find that this error condition isn't exercised in our regression tests. I added some coverage, but maybe that's overkill? regards, tom lane
Commits
-
Improve the error message for an inappropriate column definition list.
- ce90f075f0d8 14.0 landed