Guys,
> I find I've been stymied using server-side functions for large batch jobs
> for pretty much the same reason. I find it works better and it's more
> flexible to write client-side programs in the language of my choice that
> connect to the database and do the batch jobs.
FWIW, Gavin Sherry is working on CREATE PROCEDURE for 8.1, which may include
some ability to have multiple-transaction procedures.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco