pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
PG_COMMAND_OK oid information required 2+ messages / 2 participants [nested] [flat]
* PG_COMMAND_OK oid information required @ 2005-11-27 20:19 Andy Chambers <andychambers2002@yahoo.co.uk> 2005-11-27 22:51 ` Re: PG_COMMAND_OK oid information required Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Andy Chambers @ 2005-11-27 20:19 UTC (permalink / raw) To: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PG_COMMAND_OK oid information required 2005-11-27 20:19 PG_COMMAND_OK oid information required Andy Chambers <andychambers2002@yahoo.co.uk> @ 2005-11-27 22:51 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2005-11-27 22:51 UTC (permalink / raw) To: Andy Chambers <andychambers2002@yahoo.co.uk>; +Cc: pgsql-interfaces Andy Chambers <andychambers2002@yahoo.co.uk> writes: > 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. Huh? What oids exactly? There's no such thing as PG_RESULT_OK, so you're far from making yourself clear. > Would a patch with this change be considered? If I understand what you are after at all, it would involve a protocol change, which means the bar is a whole lot higher than "it'd be nice". regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-11-27 22:51 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-11-27 20:19 PG_COMMAND_OK oid information required Andy Chambers <andychambers2002@yahoo.co.uk> 2005-11-27 22:51 ` Tom Lane <tgl@sss.pgh.pa.us>
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