Re: function parameters - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: function parameters
Date
Msg-id Pine.BSO.4.56.0409130233570.2396@leary.csoft.net
Whole thread Raw
In response to function parameters  (Antonini Roberto <Roberto.Antonini@TILAB.COM>)
List pgsql-jdbc

On Mon, 13 Sep 2004, Antonini Roberto wrote:

> When I invoke DB-side function, I can't pass more than 16 parameters to
> it.
>
> Is it a limit imposed by JDBC driver?
>
> If it's so, how can I override it?
>

This is a backend limitation, although the default was increased to 32 in
the 7.3 release I believe.  To raise this requires some manual hacking on
config headers, try searching the archives for INDEX_MAX_KEYS.  Another
option is to use complex types or arrays to pass multiple inputs in the
same parameter.

Kris Jurka

pgsql-jdbc by date:

Previous
From: skala@gympoh.edu.sk
Date:
Subject: Problem with connection from win to linux
Next
From: Kris Jurka
Date:
Subject: Re: Customizing SSL with jdbc