Forum OpenACS Development: Using more than 16 paramters in postgresql Pl/PGSQL functions

Collapse
1: Using more than 16 paramters in postgresql Pl/PGSQL functions
Posted by Dave Bauer on 11/17/03 04:29 PM
Should we start writing functions with greater than 16 parameters. I have run into a bug in content_item__new that does not support using relation tags with the existing 16 parameter versions.

I think we should write a master function that supports all the parameters of the oracle version and rewrite the existing other versions for postgresql to call the master function. Without default parameters I think some alternate versions of functions can still be useful to simplify code in the postgresql version.

Collapse
2: Re: Using more than 16 paramters in postgresql Pl/PGSQL functions (response to 1)
Posted by Dave Bauer on 11/17/03 04:38 PM
The reasoning behind this change is that Postgresql 7.3 defaults to 32 parameters for pl/pgsql functions and OpenACS 5.0 and beyond will require at least Postgresql 7.3
Collapse
3: Re: Using more than 16 paramters in postgresql Pl/PGSQL functions (response to 1)
Posted by Don Baccus on 11/17/03 05:54 PM
Yes, since we're only supporting PG 7.3+ with 5.0 it is fine to make full use of the fact that functions by default can now have 32 parameters.