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

Since the Oracle version supports multiple files, I would think the PG version needs to be the same, but the hack to make it work makes it tricky.

For oracle you can just to empty_blob() for every blob column and it will "just work" as far as I can tell, but the PG support only allows for one __lob_id to be passed into the query.

Supporting just one blob at a time, seems reasonable, and I don't know of any existing code that actually sends more than one file at a time.

Perhaps we should change the oracle code to only support one blob also? This would make future code simpler to support on multiple databases, I think.