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