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

Поиск
Список
Период
Сортировка
От Dmitry Pogorelov
Тема Fwd: PSQL iODBC driver on mac os x 10.10.3 (Yosemite)
Дата
Msg-id CAKELO4g868Rh1FUSBx7ykNGLkirrLdBfW0sv+8gavm8bo+959Q@mail.gmail.com
обсуждение исходный текст
Ответ на PSQL iODBC driver on mac os x 10.10.3 (Yosemite)  (Dmitry Pogorelov <dalex005@gmail.com>)
Список pgsql-odbc
Дерево обсуждения

Best Regards
Dmitry Pogorelov

---------- 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.

Best Regards
Dmitry Pogorelov

2016-02-11 0:34 GMT+01:00 Adrian Klaver <adrian.klaver@aklaver.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.klaver@aklaver.com
 <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
        <mailto:adrian.klaver@aklaver.com
        <mailto:adrian.klaver@aklaver.com>>




    --
    Adrian Klaver
    adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>




--
Adrian Klaver
adrian.klaver@aklaver.com


Вложения

В списке pgsql-odbc по дате отправления: