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 ?
On 7/10/07, Richard Huxton <dev(at)archonet(dot)com> wrote:
>
> Jasbinder Singh Bali wrote:
> > Hi,
> >
> > How can I have two different transactions is a plperlu function?
> > My purpose is as follows:-
> >
> > Transaction 1 does some series of inserts in tbl_abc
> > Transaction 2 updates some columns in tbl_abc fetching records from some
> > other table.
>
> You'll have to connect back to yourself using dblink() or dbilink() -
> see contrib/ for details.
>
> Don't forget to consider what it means to have a connection string in a
> function-body either.
>
> --
> Richard Huxton
> Archonet Ltd
>