---------- Forwarded message ---------- From: Dmitry Pogorelov<dalex005@gmail.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.klaver@aklaver.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.
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: