PQoidValue have no use?

Поиск
Список
Период
Сортировка
От songsubosongtebo songsubosongtebo
Тема PQoidValue have no use?
Дата
Msg-id 20041128031759.92115.qmail@web42101.mail.yahoo.com
обсуждение исходный текст
Список pgsql-general
1.
The oid may overlap; Insert may fail if i create a
primary key on the oid column(Thank Richard Huxton and
Michael Glaesemann). So I can't locate the record I
Insert by the oid obtained by PQoidValue.
Then, PQoidValue have no use?

2.
I can use currtid2 to get the ctid after Delete. But
in this method the speed is slow down by the extra sql
query(SELECT currtid2('a'::text,...). I am very
pleasure if the ctid is not changed after Delete or a
function such as 'PQctidValue' can be found in
libpq.:)

3.
How to get ctid after Insert?

I want my code can deal with any table, so I can't add
addtional primary key on tables.


Sincerely,
Songsubo


_________________________________________________________
Do You Yahoo!?
登記免費的 @yahoo.com 中文電子郵件 @ http://chinese.mail.yahoo.com
Get your free @yahoo.com address at http://chinese.mail.yahoo.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Kamil Kaczkowski
Дата:
Сообщение: Re: row-level deadlock problem
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: (b)trim anomalies