Joe Conway wrote:
> Tom Lane wrote:
> > David Fetter <[EMAIL PROTECTED]> writes:
> > 
> >>On Thu, Oct 06, 2005 at 10:38:54PM -0400, Bruce Momjian wrote:
> >>
> >>>I don't know if people want this for 8.1 or 8.2.
> > 
> >>8.1, IMHO.  It's a bug fix. :)
> > 
> > Not unless Joe Conway signs off on it ...
> > 
> 
> I had asked on the original simple patch, and I'll ask again now -- why 
> is this needed? I don't have a clear understanding of the problem that 
> this (or the earlier) patch is trying to solve. Without that, it is 
> impossible to say whether it is a bug fix or feature.

Well, as I said in the patch email:

        The reported problem is that dblink_open/dblink_close() (for cursor
        reads) do a BEGIN/COMMIT regardless of the transaction state of the
        remote connection.  There was code in dblink.c to track the remote
        transaction state (rconn), but it was not being maintained or used.

If a remote transactions has already been started by the user,
dblink_open is going to call BEGIN, which is going to fail because there
is already an open transaction, right?

Here is an crude example:
        
        test=> BEGIN;
        BEGIN
        test=> begin;
        WARNING:  there is already a transaction in progress
        BEGIN
        test=> SELECT 1;
         ?column?
        ----------
                1
        (1 row)
        
        test=> COMMIT;
        COMMIT
        test=> COMMIT;
        WARNING:  there is no transaction in progress
        COMMIT

The BEGIN and COMMIT are only a warning though, but the early COMMIT by
the dblink_close() is a serious issue.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to