Jasbinder Singh Bali wrote:
You mean to say keep using spi_exec till I want everything in the same
transaction and the point where I want a separate transaction, use DBI ?
Yes - if you have two functions A,B then do everything as normal in
each, except you call function B using dblink() from function A. That
will give you a separate session which can commit/rollback separately
from the original.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq