Re: Stored procedures - Mailing list pgsql-jdbc

From scott.marlowe
Subject Re: Stored procedures
Date
Msg-id Pine.LNX.4.33.0310030845430.26935-100000@css120.ihs.com
Whole thread Raw
In response to Stored procedures  ("Yolanda Phillips" <yphillips@dlkconsulting.co.za>)
List pgsql-jdbc
On Fri, 3 Oct 2003, Yolanda Phillips wrote:

> Good day,
>
> I need help URGENTLY!!
>
> I'm trying to compile a Stored Function that performs either an insert or an
> update on a table. The function has 44 input parameters and returns an
> integer. When compiling the function a get an error:
>
> ERROR: functions cannot have more than 32 arguments
>
> I would just like someone to confirm this. Can a function only have 32 input
> parameters? If so, I'd have to use Prepared Statements then.

The 32 arg limit is a compile time / reinitdb parameter.  I.e. you can
change it, but you'll have to first pg_dumpall your database, recompile
postgresql with a different limit, and then restore your database to get
more than 32 args.

But there are other ways around it, like passing a record type or array to
the function.


pgsql-jdbc by date:

Previous
From: "Gordon Ross"
Date:
Subject: Re: Concurrent Connections - User only allowed one
Next
From: "scott.marlowe"
Date:
Subject: Re: Concurrent Connections - User only allowed one