BUG #14459: Error from query with too many binds has no message

Started by Nonameover 9 years ago2 messagesbugs
Jump to latest
#1Noname
sean@seantheprogrammer.com

The following bug has been logged on the website:

Bug reference: 14459
Logged by: Sean Griffin
Email address: sean@seantheprogrammer.com
PostgreSQL version: 9.6.1
Operating system: macOS
Description:

If a query is performed with more than 34464 bind parameters, the query will
fail. This is fine, but attempting to get the error message with
`PQresultErrorField` and `PG_DIAG_MESSAGE_PRIMARY` will return `NULL`. The
documentation states that the `PG_DIAG_MESSAGE_PRIMARY` field is always
present.

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: BUG #14459: Error from query with too many binds has no message

sean@seantheprogrammer.com writes:

If a query is performed with more than 34464 bind parameters, the query will
fail. This is fine, but attempting to get the error message with
`PQresultErrorField` and `PG_DIAG_MESSAGE_PRIMARY` will return `NULL`. The
documentation states that the `PG_DIAG_MESSAGE_PRIMARY` field is always
present.

Hm --- it is, or should be, always present in errors returned by the
backend. I suspect this failure is occurring on the client side; libpq
does not produce broken-down fields in its error reports at the moment.
The weird limit suggests that the underlying problem is out-of-memory
while marshaling the query.

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs