Re: audit table containing Select statements submitted

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: audit table containing Select statements submitted
Дата
Msg-id 200605121120.42118.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: audit table containing Select statements submitted  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: audit table containing Select statements submitted
Re: audit table containing Select statements submitted
Список pgsql-hackers
Andrew,

> The real problem is the message, which is now
> from the logging code's point of view basically an opaque string.
> Changing that would be a massive undertaking, especially when you think
> of the effect on the translators. 

Hmmm ... I don't see this as a problem.  Just stick the whole message into 
a single XML field.  This is one area where XML is easier that SQL; since 
it's a document format, it has no problem with a great big blob of text.  
"Unstructured Data" and all that nonsense.

Then whatever utility the user uses to *read* the XML can parse the message 
according to the user's desires.  It'll still be an improvement over the 
current format for log digestion, since it will become easy to separate 
the message from the prefix and tag (which currently it's not).

The only real issue I see is the possibility of XML codes embedded in the 
text, but that seems minor.

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: audit table containing Select statements submitted
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: audit table containing Select statements submitted