Re: Document parameter count limit - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Document parameter count limit
Date
Msg-id 3728363.1669229253@sss.pgh.pa.us
Whole thread Raw
In response to Re: Document parameter count limit  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Document parameter count limit
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Does this come up enough to document it?  I assume the error message the
> user receives is clear.

Looks like you get

    if (nParams < 0 || nParams > PQ_QUERY_PARAM_MAX_LIMIT)
    {
        libpq_append_conn_error(conn, "number of parameters must be between 0 and %d",
                           PQ_QUERY_PARAM_MAX_LIMIT);
        return 0;
    }

which seems clear enough.

I think the concern here is that somebody who's not aware that a limit
exists might write an application that thinks it can send lots of
parameters, and then have it fall over in production.  Now, I've got
doubts that an entry in the limits.sgml table will do much to prevent
that scenario.  But perhaps offering the advice to use an array parameter
will be worthwhile even after-the-fact.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Transparent column encryption
Next
From: Tom Lane
Date:
Subject: Re: Another multi-row VALUES bug