Postgres Pro
Downloads
Home   >   mailing lists

getting OID of INSERTed record in ECPG - Mailing list pgsql-interfaces

From Matthew Denny
Subject getting OID of INSERTed record in ECPG
Date
Msg-id 14587.56388.364036.838765@caracas.CS.Berkeley.EDU
Whole thread Raw
Responses getting OID of INSERTed record in ECPG  (Matthew Denny <mdenny@CS.Berkeley.EDU>)
List pgsql-interfaces
Tree view 
Does anyone know how to get the OID of an INSERTed tuple when using
PostgreSQL and ECPG?  The documentation and the mail archives state that the
OID of an INSERTed tuple is placed in sqlca.sqlerrd[1] after the SQL
call.  Although I can get sqlca to return error messages and error
codes reliably in the same program, sqlca.sqlerrd[1] always equals 0
even after a successful insert.  Has anyone had this same problem?
I'm using the Linux binary distribution of PostgreSQL 6.5.3-3.  Any
possible solutions or workarounds would be greatly appreciated.

thanks,
Matt Denny

pgsql-interfaces by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Using PGSQL via ODBC from within StarOffice ...
Next
From: Nick Rathke
Date:
Subject: Postgresql JDBC errors