Xid in log_line_prefix

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Xid in log_line_prefix
Date: 2004-09-11 03:44:57
Message-ID: 20040911034457.GA14029@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Patches,

This trivial patch adds the transaction Id to the list of escapes
available to log_line_prefix. (Note that I used the top transaction Id,
not the current subtransaction Id, which is clearly useless for PITR
purposes.)

One important question is what letter to use for this. It seemed to me
that the most obvious letter was "x". So I used that, and changed the
"postmaster and friends stop here" to "q".

I also thought of using %t, but that is already taken too.

Anyone has a better idea?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Bob [Floyd] used to say that he was planning to get a Ph.D. by the "green
stamp method," namely by saving envelopes addressed to him as 'Dr. Floyd'.
After collecting 500 such letters, he mused, a university somewhere in
Arizona would probably grant him a degree. (Don Knuth)

Attachment Content-Type Size
xid_in_log_prefix.patc text/plain 3.1 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-09-11 03:53:12 Re: Xid in log_line_prefix
Previous Message Tom Lane 2004-09-11 00:11:00 Re: pgxs default installation + various fixes