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

PG_COMMAND_OK oid information required

From: Andy Chambers <andychambers2002(at)yahoo(dot)co(dot)uk>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: PG_COMMAND_OK oid information required
Date: 2005-11-27 20:19:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
 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?
 Andy Chambers

Yahoo! Messenger  NEW - crystal clear PC to PC calling worldwide with voicemail 


pgsql-interfaces by date

Next:From: Tom LaneDate: 2005-11-27 22:51:20
Subject: Re: PG_COMMAND_OK oid information required
Previous:From: Michael FuhrDate: 2005-11-27 19:34:29
Subject: Re: pl/pyton: exceptions.ImportError: No module named email.Parser

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