Re: Autonomous Transactions

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Autonomous Transactions
Дата
Msg-id 1117642301.20484.72.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Autonomous Transactions  (Alvaro Herrera <alvherre@surnet.cl>)
Список pgsql-general
On Wed, 2005-06-01 at 10:52, Alvaro Herrera wrote:
> On Wed, Jun 01, 2005 at 03:38:01PM +0000, Matt Miller wrote:

> > I'm willing to use a different language, or even the libpq API if
> > necessary.
>
> If you really need autonomous transactions, you can establish an
> independent connection within a function in, say, PL/Perl or PL/Python.
> For example in PL/PerlU you can load the DBI driver and then use DBD::Pg
> to create another connection.  Any command and transaction you initiate
> on that other connection will be, of course, completely separate and
> independent from the connection the function is executing in.

I've done the same thing here at work with dblink.  Works a charm.

В списке pgsql-general по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: Newby to DB
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: prevent user change password?