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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html