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

Reply via email to