Re: DBLink cursors

Joe Conway wrote:
> Shridhar Daithankar wrote:
> >I was just going thr. dblink code and noticed that dblink cursors are
> >wrapped in their own transaction.
>
> yup -- been that way since 7.3 was released.
>
> >If an application instantiates a transaction to do 10 things, one of
> >which is to fetch a cursor over dblink, how will it work?
>
> I guess it won't -- you're the first person who ever complained, so
> quite possibly you're the first who's needed it.

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...

--
Kevin Brown kevin(at)sysexperts(dot)com