Re: [PATCHES] log session end - again

Bruce Momjian wrote:

>Tom Lane wrote:
>
>
>>Larry's idea about combining PID and backend start time didn't sound too
>>unreasonable to me.
>>
>>
>
>Wow, like the idea too --- pid plus time_t start time of backend.
>Actully, it would be good to have star time first so you can sort
>everything in order of start time.
>
>

Yes. Of course, you would need either to sort additionally on log
timestamp or use an order-preserving sort.

Based on Larry's idea, I had in mind to provide a third escape in the
log_line_info string (in addition to the %U and %D that I had previously
done) of %S for sessionid, which would look something like this:
402251fc.713f

I will start redoing this feature when the log_disconnections patch is
dealt with.

cheers

andrew