On Mon, Jul 16, 2012 at 06:04:23AM +0900, Hiroshi Inoue wrote:
> (2012/07/16 1:40), Lionel Elie Mamane wrote:
>> On Mon, Jul 16, 2012 at 12:50:40AM +0900, Hiroshi Inoue wrote:
>>> (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:
>>>>>> 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?
> Please set the following.
> Protocol = 7.4
That is not among the choices offered by ODBCConfig; I can take 6.4,
6.3 or 6.2.
Editing the ~/.odbc.ini file by hand, indeed it "solves" the issue. As
does completely removing the "Protocol = ..." line.
> Setting
> UseServerSidePrepare = 1
> is also recommended.
That is also not among the choices offered by ODBCConfig; I have the
following boolean choices:
ReadOnly
RowVersioning
ShowSystemTables
ShowOidColumn
FakeOidIndex
I'm fairly sure ODBCConfig does not have these options (and possible
values) hardcoded, but gets them by interrogating the driver (or
rather its companion libodbcpsqlS.so?); 't would be a good idea to
keep that in sync with what the actual driver supports.
--
Lionel