From: songsubosongtebo songsubosongtebo <songsubosongtebo@yahoo.com>
To: pgsql-interfaces@postgresql.org
Subject: PQoidValue have no use?
Date: Mon, 29 Nov 2004 20:16:35 +0800 (CST)
Message-ID: <20041129121635.77385.qmail@web42104.mail.yahoo.com> (raw)
I posted this to pgsql-generl@postgresql.org
yesterday, and wait someone can enlighten me.
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 single
record I Insert by the oid obtained from 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!?
µn°O§K¶Oªº @yahoo.com ¤¤¤å¹q¤l¶l¥ó @ http://chinese.mail.yahoo.com
Get your free @yahoo.com address at http://chinese.mail.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: songsubosongtebo@yahoo.com
Subject: Re: PQoidValue have no use?
In-Reply-To: <20041129121635.77385.qmail@web42104.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox