(2012/07/15 14:02), Lionel Elie Mamane wrote:
> On Sun, Jul 15, 2012 at 06:50:27AM +0900, Hiroshi Inoue wrote:
>> (2012/07/10 23:27), Lionel Elie Mamane wrote:
>
>>>> Working with PostgreSQL version 8.4.12-0ubuntu11.04 and with ODBC
>>>> driver versions 1:08.03.0200-1.2 (supplied with ubuntu-natty (11.04))
>>>> and pgsqlodbc-09.01.0100 (built locally), I have managed to provoke a
>>>> segfault by calling SQLSpecialColumns with a null string for the table
>>>> name. This call is, of course, a strange thing to do, and I cannot
>>>> imagine any good result. Still, a segfault seems a disproportionate
>>>> punishment for doing something silly.
>
>>> Also, the ultimate reason for this "strange thing" is that
>
>>> SQLColAttribute( (SQLHANDLE) 0x1ec7850,
>>> (SQLUSMALLINT) 1,
>>> (SQLUSMALLINT) 15,
>>> (SQLPOINTER) 0x1eb2640,
>>> 128,
>>> (SQLSMALLINT *) 0x7fffffff97de,
>>> NULL);
>
>>> where 15 == SQL_DESC_TABLE_NAME == SQL_COLUMN_TABLE_NAME
>>> returns (writes at 0x1eb2640) an empty string for this query:
>
>>> SELECT "Num" "Numero", "data" FROM "foo"."Table1"
>
>> What is your environment e.g. the version of your PG server
>> or the version of your psqlodbc?
>
> On Debian GNU/Linux amd64, Debian packages.
>
> Client:
> unixodbc 2.2.14p2-5
> psqlodbc 09.01.0100
> libpq5 9.1.3
> Server:
> postgresql 9.0.6
SQLColattribute returns non null string here under Windows environment.
Well how are you setting odbc.ini?
regards,
Hiroshi Inoue