X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 348043A5110 for ; Mon, 29 Nov 2004 12:16:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93316-10 for ; Mon, 29 Nov 2004 12:16:34 +0000 (GMT) Received: from web42104.mail.yahoo.com (web42104.mail.yahoo.com [66.218.93.197]) by svr1.postgresql.org (Postfix) with SMTP id 4CF003A50F4 for ; Mon, 29 Nov 2004 12:16:35 +0000 (GMT) Received: (qmail 77387 invoked by uid 60001); 29 Nov 2004 12:16:35 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=cXtblzCQP82IV9vfjuo+ENA+zx1/35pPgkEsM44LvLR+kAfLNhtAPX0ec0sRIjT/CiE81HPYCWh2kkYdJDVv+391Ga0mhZPsdwFLiSR7NnrluLTChZjJ3+UW+9sgJCdlF9jCAPAK3FuHEZnkJFHsLKg0kRmeKVVTw+BHAqUvLjc= ; Message-ID: <20041129121635.77385.qmail@web42104.mail.yahoo.com> Received: from [218.20.62.179] by web42104.mail.yahoo.com via HTTP; Mon, 29 Nov 2004 20:16:35 CST Date: Mon, 29 Nov 2004 20:16:35 +0800 (CST) From: songsubosongtebo songsubosongtebo Subject: PQoidValue have no use? To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=big5 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/40 X-Sequence-Number: 5166 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!? 登記免費的 @yahoo.com 中文電子郵件 @ http://chinese.mail.yahoo.com Get your free @yahoo.com address at http://chinese.mail.yahoo.com