Forum OpenACS Q&A: Occasional Error: ExecMakeFunctionResult

Hi,

I occasionally get an error when using the file storage system.  It
seems to be triggered when I add a new file or folder, and the
function fs_order_files gets called.

The error is as follows:

[31/Oct/2000:17:21:06][16588.258052][-conn15-] Error: Ns_PgExec:
result status: 7 message: ERROR:  ExecMakeFunctionResult: too many
arguments

[31/Oct/2000:17:21:06][16588.258052][-conn15-] Error: nsd.db: error
(localhost::wcs, ERROR:  ExecMakeFunctionResult: too many argumen
ts
): select file_id, fs_level_gen(file_id,1) as the_level
                          from fs_files
                        order by fs_connect_by(file_id)
[31/Oct/2000:17:21:06][16588.258052][-conn15-] Error: nsd.tcl:
Database operation "select" failed (exception NSDB, "Query was not a
statement returning rows.")

Anyone got any ideas?  I tracked the error message down in the
postgres installation (backend/executor/execQual.c) but I can't
really get to the bottom of it.

Thanks for any help!