I'm using Postgres 8.4.1 and psqlodbc 08.04.0200. I'm trying to execute a statement INSERT INTO table/values RETURNING id to get the serial id. Problem is, SQLNumResultCols shows that there are zero columns. The statement I used works fine in pgadmin. This seems really basic and I am somewhat new to databases and odbc, but does anyone have a solution?
pgsql-odbc by date
|Next:||From: Gustavo Pinsard||Date: 2010-10-07 11:11:57|
|Subject: Re: INSERT INTO ... RETURNING id not behaving as expected
|Previous:||From: Craig Ringer||Date: 2010-10-07 02:04:39|
|Subject: [BUGS] BUG #5694: Postgres ODBC SQLTables is not working correctly|