Forum OpenACS Development: Re: -blob_files parameter to db procs behaves differently in Postgresql than Oracle

The intermittent failure is due to not using aolserver generated tmp filenames when unzipping a folder before adding it to the content repository.

So we had filenames like you see above. /var/tmp/tmp.86.qrRKrm/Test Document.pdf

When you upload a single file it uses ns_mktmp to generate the filename for the tmp file so it is guaranteed to contain no spaces.

I can work around this by using tmp filenames from within the zip file that don't have spaces, but I think the error is in db_dml where it passes the list to ns_pg.

ns_pg blob_dml_file $db [uplevel {set __lob_id}] $blob_files