Re: DBLink cursors

From: Joe Conway <mail(at)joeconway(dot)com>
To:
Cc: Kevin Brown <kevin(at)sysexperts(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: DBLink cursors
Date: 2003-04-17 02:26:56
Message-ID: 3E9E10F0.9020209@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joe Conway wrote:
> Kevin Brown wrote:
>
>> Won't dblink's attempt to initiate a transaction simply return with a
>> warning if a transaction is already in progress? This is what psql
>> does, and it's also what happens with Perl DBI, so it's only if dblink
>> freaks out that there will be a problem.
>>
>> I wouldn't expect it to abort the entire (already running)
>> transaction upon receipt of a warning...
>

[...snip...]

>
> regression=# SELECT dblink_close('rmt_foo_cursor');

But then again, dblink_close issues a COMMIT, so beware...

Joe

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Brown 2003-04-17 02:35:25 Re: pg_clog woes with 7.3.2 - Episode 2
Previous Message Joe Conway 2003-04-17 02:19:50 Re: DBLink cursors