I am attempting to port and application that was designed for MS-SQL to Postgres and bumped into a limitation of pg functions, namely that pg functions can only support 32 parameters. Our app takes records from a only cobol file(s) and populates an SQL table(s), such that one table in the db = one file from the file system. With MS-SQL we use a stored procedure to handle the update/inserts and pass the fields information as parameters to the procedure as part of "EXECUTE" command. Sometimes there can be as many as 50+ parameters to be passed. Typically pg functions as offered as the equivalent to "store procedures", however, in this case seems to be a limitation. If anyone has any other suggestions, we would appreciate some input.
