From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Margus(at)tpf(dot)co(dot)jp, "Va\"li(at)tpf(dot)co(dot)jp"(at)viscomail(dot)tpf(dot)co(dot)jp, "\\"(at)postgresql(dot)org, " <m(dot)vali(at)aprote(dot)com>"(at)postgresql(dot)org |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: getting rid of CTIDs |
Date: | 2002-05-14 23:45:59 |
Message-ID: | 3CE1A1B6.380A74E6@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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;
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Evans | 2002-05-15 09:48:52 | psqlodbc-07_02_0001 |
Previous Message | Patrick Hatcher | 2002-05-14 19:15:00 | no data returning multiple recordsets from single batch sql send |