X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1C456DBCE4 for ; Sun, 27 Nov 2005 16:25:50 -0400 (AST) 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 19139-10 for ; Sun, 27 Nov 2005 16:25:49 -0400 (AST) X-Greylist: delayed 00:06:39.781182 by SQLgrey- Received: from web26910.mail.ukl.yahoo.com (web26910.mail.ukl.yahoo.com [217.146.176.99]) by svr1.postgresql.org (Postfix) with SMTP id 226A8DAFBD for ; Sun, 27 Nov 2005 16:25:46 -0400 (AST) Received: (qmail 67268 invoked by uid 60001); 27 Nov 2005 20:19:07 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=tnk6u5Gdm3bdu2ezeMUVLOw7XixqA2ioKX48IBaC8zqaBC4eWZQWEgwMEa3wCrhzQdw43cG/gEQ1+pyRNANfJFVboWz2y4cwoZHoqAedCqrA4Xbesn422DDgt1+ZvWJqhVn7lr/0AC0fYgR8kR6Z4Avm/9Z9P9MduikA5WEohqk= ; Message-ID: <20051127201907.67266.qmail@web26910.mail.ukl.yahoo.com> Received: from [213.40.131.65] by web26910.mail.ukl.yahoo.com via HTTP; Sun, 27 Nov 2005 20:19:07 GMT Date: Sun, 27 Nov 2005 20:19:07 +0000 (GMT) From: Andy Chambers Subject: PG_COMMAND_OK oid information required To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1733281080-1133122747=:62334" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.48 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.48 X-Spam-Level: X-Archive-Number: 200511/66 X-Sequence-Number: 5862 --0-1733281080-1133122747=:62334 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, Would it be possible to provide more information in the PGResult object (or rather its associated functions) about operations that don't return a value of PG_RESULT_OK. Specifically, I believe, it would be useful for clients to know the oid's of values being inserted or updated. That way, if it realizes there are many similar operations to carry out, it would be easier to use PQExecParams. The only way I can see of doing this currently would be to issue a select from table limit 1 to get the oids, and then prepare the insert statement using the info retrieved from the select. Am I missing something? Would a patch with this change be considered? Thanks, Andy Chambers --------------------------------- Yahoo! Messenger NEW - crystal clear PC to PC calling worldwide with voicemail --0-1733281080-1133122747=:62334 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi,

Would it be possible to provide more information in the PGResult object (or rather its associated functions) about operations that don't return a value of PG_RESULT_OK.  Specifically, I believe, it would be useful for clients to know the oid's of values being inserted or updated. 

That way, if it realizes there are many similar operations to carry out, it would be easier to use PQExecParams.  The only way I can see of doing this currently would be to issue a

select <cols to insert>
from table
limit 1

to get the oids, and then prepare the insert statement using the info retrieved from the select.  Am I missing something?  Would a patch with this change be considered?

Thanks,
Andy Chambers

Yahoo! Messenger NEW - crystal clear PC to PC calling worldwide with voicemail --0-1733281080-1133122747=:62334--