Re: logging as inserts

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: logging as inserts
Дата
Msg-id 200503031414.50818.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: logging as inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: logging as inserts  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Tom,

> But log_line_prefix works fine for all destinations, which is exactly
> why this new facility isn't a destination.  You're just confusing
> matters by wanting to treat it as one.

Hmmm ... hey, if we just allowed extra text in log_line_prefix, and allowed %$ 
to enclose the statement with literal quoting, you could do this all through 
log_line_prefix, as:

log_line_prefix='INSERT INTO pg_log VALUES ( %u, %p, ''%t'', ''%$'')'

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Solving hash table overrun problems
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: logging as inserts