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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend