Postgres Pro
Downloads
Home   >   mailing lists

INSERT INTO ... RETURNING id not behaving as expected with SQLNumResultCols - Mailing list pgsql-odbc

From Ryan Pfeiffer
Subject INSERT INTO ... RETURNING id not behaving as expected with SQLNumResultCols
Date
Msg-id 93053.31124.qm@web31806.mail.mud.yahoo.com
Whole thread Raw
Responses Re: INSERT INTO ... RETURNING id not behaving as expected with SQLNumResultCols  (Gustavo Pinsard <pinsard@rocksolid.com.br>)
List pgsql-odbc
Tree view 
I'm using Postgres 8.4.1 and psqlodbc 08.04.0200. I'm trying to execute a statement INSERT INTO table/values RETURNING
idto get the serial id. Problem is, SQLNumResultCols shows that there are zero columns. The statement I used works fine
inpgadmin. This seems really basic and I am somewhat new to databases and odbc, but does anyone have a solution? 

Thanks,
Ryan

pgsql-odbc by date:

Previous
From: Craig Ringer
Date:
Subject: [BUGS] BUG #5694: Postgres ODBC SQLTables is not working correctly
Next
From: Gustavo Pinsard
Date:
Subject: Re: INSERT INTO ... RETURNING id not behaving as expected with SQLNumResultCols