Re: Implementing 2 different transactions in a PL/Perl function
| От | Jasbinder Singh Bali |
|---|---|
| Тема | Re: Implementing 2 different transactions in a PL/Perl function |
| Дата | |
| Msg-id | a47902760707101252w572a307dh8c898bf205bbfbde@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Implementing 2 different transactions in a PL/Perl function (Richard Huxton <dev@archonet.com>) |
| Ответы |
Re: Implementing 2 different transactions in a PL/Perl
function
|
| Список | pgsql-general |
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@archonet.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
В списке pgsql-general по дате отправления: