Re: DBLink cursors - Mailing list pgsql-hackers

From Joe Conway
Subject Re: DBLink cursors
Date
Msg-id 3E9E10F0.9020209@joeconway.com
Whole thread Raw
In response to Re: DBLink cursors  (Joe Conway <mail@joeconway.com>)
Responses Re: DBLink cursors  (Kevin Brown <kevin@sysexperts.com>)
List 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



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: DBLink cursors
Next
From: Kevin Brown
Date:
Subject: Re: pg_clog woes with 7.3.2 - Episode 2