Forum OpenACS Q&A: Getting Around 16 parameter limit redux

Okay, I just spent 30 minutes reading the forums trying to suss out ways around the 16 parameter limit on postgres functions:  It seems that I have 4 choices:

1) recompile my postgres installation to take more parameters
  -this will mean that my package can't be part of the
    standard distribution.

2) overloading and creating a bunch of foo__new procs
  - this doesn't work for me since I will sometimes need all
      the parameters at once.

3) Doing a seperate create and update for when I have too much
  information.
  - ick.

4) encoding my parameters and stuffing them into a single
  parameter.
  - IE making a list of parameters and putting it into a single parameter. This seems pretty ugly as well.

Does anyone have a suggestion for me?

Collapse
Posted by Don Baccus on
Yeah ... use the oacs-4-6 head which will be 4.6.2 beta1 this weekend and which works with PG 7.3.2 ...

Which has a limit of 32 (!) parameters rather than 16 oh yeah baby life's looking a lot better!

Collapse
Posted by Carl Coryell-Martin on
Okay I downloaded the HEAD and installed postgres7.3.2 and now my server doesn't bootstrap. 😟

The error is:

[28/Mar/2003:10:08:55][3805.24580][-conn0-] Error: Error sourcing /export/dev/mdb/packages/acs-bootstrap-installer/installer/install-data-model.tcl:
unknown command
    while executing
"ns_xml node get attr $element $attribute"
    (procedure "apm_attribute_value" line 3)
...

any suggestions?

Collapse
Posted by Don Baccus on
Not head - the oacs-4-6 branch.  Or wait until this weekend when we expect to put up the first 4.6.2 beta tarball.
Collapse
Posted by Tilmann Singer on
I had the same bootstrap error yesterday on HEAD of the main branch. After upgrading nsxml from 1.4 to 1.5 it went away.

I hope someone is able to add this to the bootstrap checks on startup.