Re: cmin increments by 2 except in 7.4? - Mailing list pgsql-general

From Tom Lane
Subject Re: cmin increments by 2 except in 7.4?
Date
Msg-id 10942.1107240835@sss.pgh.pa.us
Whole thread Raw
In response to cmin increments by 2 except in 7.4?  (Michael Fuhr <mike@fuhr.org>)
Responses Re: cmin increments by 2 except in 7.4?
List pgsql-general
Michael Fuhr <mike@fuhr.org> writes:
> I've noticed that in PostgreSQL 7.4, successive commands in a
> transaction get cmin values that increment by 1, but in other
> versions cmin increments by 2.  Example:

Not sure about pre-7.4, but 8.0 is doing this because of a faulty
translation of list-munging stuff.  PortalRunMulti contains

        /*
         * Increment command counter between queries, but not after the
         * last one.
         */
        if (planlist_item != NULL)
            CommandCounterIncrement();

but planlist_item will *never* be NULL here.  Should be testing
lnext(planlist_item), I think.  Neil?

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: cmin increments by 2 except in 7.4?
Next
From: Pritesh Shah
Date:
Subject: dumping and restoring user information.