Re: CURRENT OF cursor without OIDs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CURRENT OF cursor without OIDs
Дата
Msg-id 8675.997207267@sss.pgh.pa.us
обсуждение исходный текст
Ответ на CURRENT OF cursor without OIDs  (Ian Lance Taylor <ian@airs.com>)
Список 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 по дате отправления:

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: Client Side Connection Pooling
Следующее
От: "Dave Cramer"
Дата:
Сообщение: FW: [JDBC] BIGINT vs Java's long