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;