Re: MyLog and CommLog options

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Daniil Megrabyan <danil(dot)megrabjan(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: MyLog and CommLog options
Date: 2017-02-04 10:53:25
Message-ID: bc09bf4f-2b93-5ac8-5f4b-4f6b8e7e26c6@dream.email.ne.jp
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Daniil,

On 2017/02/04 17:44, Daniil Megrabyan wrote:
>> 4 февр. 2017 г., в 11:30, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> написал(а):
>>
>>> miniBagroff:odbc danilabagroff$ cat /usr/local/etc/odbc.ini
>>> [pg_abra1]
>>> Driver = PostgreSQL
>>> Host = localhost
>>> Port = 5432
>>> Protocol = 6.4
>>> FetchBufferSize = 99
>>> Database = abra1
>>> ReadOnly = no
>>> MyLog = /tmp/mylog2.log
>> Mylog isn't an option, instead try
>>
>> Debug = 1
>>
>> Possibly you will find /tmp/mylog_xxxx.
> Bingo! It works for tiny example with isql when I put Debug option into odbc.ini(for DSN). Is there is any way to enable this option for all driver(in odbcinst.ini) connections? When I’m trying my real life example(with DSNless connections) the mylog, unfortunately, does not appear.

There's no way to enable this option at once for all driver connections.
The option is for debug and makes rather heavy demands on execution..
For DSNless connections, use connection strings like
Driver=PostgreSQL;server=localhost;.database=abra1;...;Debug=1

regards,
Hiroshi Inoue

> Thank you.
>
> — Daniil A Megrabyan —

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Daniil Megrabyan 2017-02-04 11:07:55 Re: [HY000] no error information; Error while preparing parameters
Previous Message Daniil Megrabyan 2017-02-04 08:44:41 Re: MyLog and CommLog options