MySQL accounting stop query

2005-12-07 Thread Dennis Skinner
I noticed that the stop query changed at some point between 0.9.3 and 1.0.1. Here are the queries: ## 0.9.3 ## accounting_stop_query = "UPDATE ${acct_table2} SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets

Re: accounting stop query

2004-02-19 Thread ROY
figured it out ;-) postgres's transaction feature answered my prayer.. On Thu, 2004-02-19 at 16:47, ROY wrote: > hi list, > > is it possible to have two 'accounting_stop_query' on postgressql.conf > > or > > i need to setup something like > > modules { > sql { > ... >

accounting stop query

2004-02-19 Thread ROY
hi list, is it possible to have two 'accounting_stop_query' on postgressql.conf or i need to setup something like modules { sql { ... ... blah blah ... ... } sql2 { ...