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!