Skip site navigation (1) Skip section navigation (2)

PQoidValue have no use?

From: songsubosongtebo songsubosongtebo <songsubosongtebo(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PQoidValue have no use?
Date: 2004-11-28 03:17:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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?

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

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.


Do You Yahoo!?
登記免費的 中文電子郵件 @
Get your free address at

pgsql-general by date

Next:From: Bruce MomjianDate: 2004-11-28 03:23:33
Subject: Re: (b)trim anomalies
Previous:From: Kamil KaczkowskiDate: 2004-11-28 03:12:36
Subject: Re: row-level deadlock problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group