Re: [PATCH] Better logging of COPY queries if log_statement='all'

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCH] Better logging of COPY queries if log_statement='all'
Дата
Msg-id 26709.1476715953@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCH] Better logging of COPY queries if log_statement='all'  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: [PATCH] Better logging of COPY queries if log_statement='all'  (Aleksander Alekseev <a.alekseev@postgrespro.ru>)
Re: [PATCH] Better logging of COPY queries if log_statement='all'  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> On 10/17/2016 09:57 AM, Aleksander Alekseev wrote:
>> Sometimes it's useful to log content of files used in COPY ... TO ... and
>> COPY ... FROM ... queries. Unfortunately PostgreSQL doesn't allow to do
>> it, even if log_statement='all'. Suggested patch fixes this.

> I'm not in favor of this, especially if it's not even optional. 

I'm not either.  It sounds good when you're looking at toy examples,
but not when it means repeating gigabytes of COPY data into the log.
        regards, tom lane



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

Предыдущее
От: Shay Rojansky
Дата:
Сообщение: Re: macaddr 64 bit (EUI-64) datatype support
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Replace PostmasterRandom() with a stronger way of generating ran