The following bug has been logged online:

Bug reference: 2004
Logged by: Henning
Email address: andersen (AT) modelcreator (DOT) com
PostgreSQL version: 8.0
Operating system: Windows XP
Description: SQL_COLUMN_AUTO_INCREMENT & SQL_DESC_AUTO_UNIQUE_VALUE
not working
Details:

Hello,
I can't retrieve type information via ODBC about the type "SERIAL".

When creating a table with a column having the type SERIAL it is changed
into an int4 with a default value to a sequence as I understood it.
I can retrieve information about the type int4 and other attributes (using
SQLColumns) but I don't see how I can retrieve information about the
sequencing.

I tried to use the following:
SQLColAttributes with attribute: SQL_COLUMN_AUTO_INCREMENT
SQLColAttribute with attribute: SQL_DESC_AUTO_UNIQUE_VALUE

For a column in a table that I created as type SERIAL these return negative
result (meaning it is NOT a SERIAL column).
This is in my mind a bug in the odbc driver.

I'm using odbc driver: 8.00.00.04 dated January 17th 2005.

Thanks,
Henning

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq