Re: getting rid of CTIDs

Margus Va"li wrote:
>
> Now I have a problem with 7.1.2, psqlodbc-07_02_0001
> <http://odbc.postgresql.org/ftpsite/odbc/versions/msi/psqlodbc-07_02_0001.zip>,
> server-side updateable
> cursor, I'm updating a row, then trying to update it another time but
> will get a locking error
> since it doesn't seem to fetch the new CTID (fetched 0 rows)

It was my fault at server side, sorry.
Please apply the following patch to src/backend/access/heap/heapam.c.

Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

===================================================================
RCS file: /cvsroot//pgsql/src/backend/access/heap/heapam.c,v
retrieving revision 1.129
retrieving revision 1.129.2.1
diff -c -r1.129 -r1.129.2.1
*** pgsql/src/backend/access/heap/heapam.c    2002/01/15 22:14:17    1.129
--- pgsql/src/backend/access/heap/heapam.c    2002/05/01 01:27:31    1.129.2.1
***************
*** 8,14 ****
   *
   *
   * IDENTIFICATION
!  *      $Header: /cvsroot//pgsql/src/backend/access/heap/heapam.c,v 1.129
2002/01/15 22:14:17 tgl Exp $
   *
   *
   * INTERFACE ROUTINES
--- 8,14 ----
   *
   *
   * IDENTIFICATION
!  *      $Header: /cvsroot//pgsql/src/backend/access/heap/heapam.c,v
1.129.2.1 2002/05/01 01:27:31 inoue Exp $
   *
   *
   * INTERFACE ROUTINES
***************
*** 1004,1010 ****
                         snapshot, 0, (ScanKey) NULL);

      linkend = true;
!     if ((t_data->t_infomask & HEAP_XMAX_COMMITTED) &&
          !ItemPointerEquals(tid, &ctid))
          linkend = false;

--- 1004,1010 ----
                         snapshot, 0, (ScanKey) NULL);

      linkend = true;
!     if ((t_data->t_infomask & HEAP_XMIN_COMMITTED) != 0 &&
          !ItemPointerEquals(tid, &ctid))
          linkend = false;