Fwd: PSQL iODBC driver on mac os x 10.10.3 (Yosemite)

Best Regards
Dmitry Pogorelov

---------- Forwarded message ----------
From: Dmitry Pogorelov <dalex005(at)gmail(dot)com>
Date: 2016-02-11 0:54 GMT+01:00
Subject: Re: [ODBC] PSQL iODBC driver on mac os x 10.10.3 (Yosemite)
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>

I've just run the following scripts:

delete from test_table;

ALTER TABLE test_table
ADD COLUMN id integer;

ALTER TABLE test_table
ADD PRIMARY KEY (id);

insert into test_table (id, a) values (1, 1);

It didn't help, I have the empty table's list yet on LO. New log is
attached. You know, when I compared the mylogs I noticed a difference in
sequence of methods' calls after SQLTables function. On windows:
SQLGetInfoW, SQLNumResultCols, several calls of SQLColAttributeW, several
calls of SQLBindCol and only after that SQLFetch, on OS X:
SQLNumResultCols, SQLFetch messed with SQLColAttributeW, SQLGetData. I
don't know maybe it's related to iODBC, maybe not.

Best Regards
Dmitry Pogorelov

2016-02-11 0:34 GMT+01:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> On 02/10/2016 03:34 PM, Dmitry Pogorelov wrote:
>
>> Hi Adrian,
>>
>> No, just a simple test table, without a primary key. I used the script:
>>
>> CREATE TABLE test_table
>> (
>> a integer
>> )
>> WITH (
>> OIDS=FALSE
>> );
>> ALTER TABLE test_table
>> OWNER TO postgres;
>>
>
> So what happens if you add a primary key?
>
>
>> Best Regards
>> Dmitry Pogorelov
>>
>> 2016-02-11 0:28 GMT+01:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>:
>>
>>
>> On 02/10/2016 02:18 PM, Dmitry Pogorelov wrote:
>>
>> Hi,
>>
>> Sorry for the too late answer but at last I could get free time
>> for the
>> issue. Still I have the problem related to not shown table list in
>> LibreOffice. I've built the latest version of 32/64 bit
>> postgresql odbc
>> driver (09.05.0100) but already under El Capitan OS X (10.11.3)
>> with
>> iODBC 3.52. I've tried to use the driver by different versions
>> of 32 bit
>> LibreOffice - didn't help. I turned on mylog and got logs
>> (attached).
>> There was just only one "test_table" table with one "a" column. In
>> LibreOffice in tables I saw only empty list, without any tables.
>>
>>
>> I gave up on LO/OO Base as a database frontend some time ago as it's
>> performance was spotty at best. I do remember that LO/OO was finicky
>> about there being a primary key on a table.
>>
>> Does the table you mention have a primary key?
>>
>>
>> Best Regards,
>> Dmitry
>>
>> Best Regards
>> Dmitry Pogorelov
>>
>>
>>
>>
>> All I can think to do is enable MyLog and/or CommLog:
>>
>> https://odbc.postgresql.org/docs/config.html
>>
>> and see what happens when you use LO or Excel. FYI, logging
>> in
>> particular MyLog, will really slow things down.
>>
>>
>> Best Regards
>> Dmitry Pogorelov
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>>
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>