--On Tuesday, August 05, 2003 16:27:55 -0400 Tom Lane <[EMAIL PROTECTED]> wrote:
Josh Berkus <[EMAIL PROTECTED]> writes:Tabs cause issues in syslog output if I remember correctly.From my perspective, we could really use a "delimiter" between the "fields" of log output which is unlikely to appear within those fields instead of parsing by character count, rather than making dbname a special case.
Well, Andrew was arguing that space is a likely character in dbnames, but then again it's possible to put "]" into dbnames. I think the only way to make this completely unambiguous would be to introduce a quoting convention for dbnames (and usernames when those get added). But if the goal is to allow simple parsing of log entries, that won't improve matters at all.
My feeling about it is that DBAs who want to automatically parse log entries can just forbid spaces in the dbnames and usernames they allow. The KISS principle applies here.
A variant (which'd be okay with me) is to separate these fields with tabs instead of spaces; then the rule for DBAs would be "don't allow tabs in db/user names".
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
-- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
