ERROR: Procedures cannot take more that 16 arguments..

Dev Shed Forums Sponsor:

November 13th, 2002, 03:15 AM

dax

Junior Member

Join Date: Nov 2002

Location: philippines

Posts: 4

Time spent in forums: < 1 sec
Reputation Power: 0

ERROR: Procedures cannot take more that 16 arguments..

Hi,
I'm new to PostGres... When I created a stored function, an insert function which has 31 arguments, I recieve this error. Is this the limitation of PostGres? Or I miss somthing here?
Please do help me, thanks a lot....

November 13th, 2002, 10:02 AM

rycamor

Gödelian monster

Join Date: Jul 1999

Location: Central Florida, USA

Posts: 2,306

Time spent in forums: 3 Days 6 h 42 m 51 sec
Reputation Power: 60

Yes, if you look in the Notes section at the bottom of this page, you will see:

Quote:

(from pgsql-general) As of PostgreSQL 7.2.x the maximum number of arguments that can be used in a function is 16. You can increase this limit by editing FUNC_MAX_ARGS in src/include/pg_config.h, recompile and re-initdb. Be forwarned there is little data on the performance implications on doing this.

You can probably best handle this simply by re-thinking your function. For example you might be able to make one argument as an array (http://www.postgresql.org/idocs/index.php?arrays.html), and then extract all your elements inside the function for your insert statement.

If you are having any more trouble, feel free to post your function code here, and we can suggest alternatives.

__________________
The real n-tier system:

FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

Amazon wishlist -- rycamor (at) gmail.com

Last edited by rycamor : November 13th, 2002 at 11:48 AM.

December 4th, 2002, 05:07 PM

rycamor

Gödelian monster

Join Date: Jul 1999

Location: Central Florida, USA

Posts: 2,306

Time spent in forums: 3 Days 6 h 42 m 51 sec
Reputation Power: 60

Hey dax,

If you hadn't noticed, PostgreSQL 7.3 is out. It's a major release. Among many new improvements, functions can now take up to 32 parameters.

Viewing: Dev Shed Forums > Databases > PostgreSQL Help > ERROR: Procedures cannot take more that 16 arguments..

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump