Re: audit table containing Select statements submitted - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: audit table containing Select statements submitted
Date
Msg-id 44651F82.9060605@commandprompt.com
Whole thread Raw
In response to Re: audit table containing Select statements submitted  (Josh Berkus <josh@agliodbs.com>)
Responses Re: audit table containing Select statements submitted
List pgsql-hackers
Josh Berkus wrote:
> Tom,
> 
>> This argument strikes me as nonsense.  You've got a utility that's smart
>> enough to parse the very-free-format message bodies, but it's going to
>> be too confused by the log line prefix?
> 
> Having tinkered a little with PQA, yes, actually.  The issue is that the 
> "message" text can easily be multi-line and contain a vast variety of 
> special characters.  The issue is figuring out where the prefix, the tag 
> and the message begin and end.  And our text log format makes that a PITA.
> 

Hmmm... well why don't we add log_line_suffix :)

Joshua D. Drake

-- 
           === The PostgreSQL Company: Command Prompt, Inc. ===     Sales/Support: +1.503.667.4564 || 24x7/Emergency:
+1.800.492.2240    Providing the most comprehensive  PostgreSQL solutions since 1997
http://www.commandprompt.com/




pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: audit table containing Select statements submitted
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Querying libpq compile time options