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

INSERT INTO ... RETURNING id not behaving as expected with SQLNumResultCols

From: Ryan Pfeiffer <malice_ryan(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: INSERT INTO ... RETURNING id not behaving as expected with SQLNumResultCols
Date: 2010-10-07 04:04:20
Message-ID: 93053.31124.qm@web31806.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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?

Thanks,
Ryan


      

Responses

pgsql-odbc by date

Next:From: Gustavo PinsardDate: 2010-10-07 11:11:57
Subject: Re: INSERT INTO ... RETURNING id not behaving as expected with SQLNumResultCols
Previous:From: Craig RingerDate: 2010-10-07 02:04:39
Subject: [BUGS] BUG #5694: Postgres ODBC SQLTables is not working correctly

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