Re: CURRENT OF cursor without OIDs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CURRENT OF cursor without OIDs
Date
Msg-id 8675.997207267@sss.pgh.pa.us
Whole thread Raw
In response to CURRENT OF cursor without OIDs  (Ian Lance Taylor <ian@airs.com>)
List pgsql-hackers
Ian Lance Taylor <ian@airs.com> writes:
> Anyhow, I see that there is a move afoot to eliminate mandatory OIDs.
> My question now is: if there is no OID, is there any comparable way to
> implement CURRENT OF cursor?  Basically what is needed is some way to
> identify a particular row between a SELECT and an UPDATE.

I'd look at using TID.  Seems like that is more efficient anyway (no
index needed).  Hiroshi has opined that TID is not sufficient for ODBC
cursors, but it seems to me that it is sufficient for SQL cursors.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Client Side Connection Pooling
Next
From: "Dave Cramer"
Date:
Subject: FW: [JDBC] BIGINT vs Java's long