Re: Transactions

2019-04-09 Thread Melvin Davidson
In addition to what Andreas has suggested, you should also verify user claims by A. Have them show you the query they executed, B. Verify they have appropriate SELECT, INSERT, UPDATE ad/or DELETE permissions on the tables involved. On Tue, Apr 9, 2019 at 6:10 AM Achilleas Mantzios <

Re: Transactions

2019-04-09 Thread Achilleas Mantzios
On 9/4/19 12:26 μ.μ., Karl Martin Skoldebrand wrote: Hi, Is there a way to track “transactions” by default (i.e. without anyone having set up anything specific). The problem I am facing is that users are claiming that settings are disappearing with them doing anything to affect them. It would

Sv: RE: Transactions

2019-04-09 Thread Andreas Joseph Krogh
På tirsdag 09. april 2019 kl. 11:56:28, skrev Karl Martin Skoldebrand < ks0c77...@techmahindra.com >: How much impact on performance and disk space would this or set log_min_duration_statement=0 have? I have no idea as to how common this is, or when it

RE: Transactions

2019-04-09 Thread Karl Martin Skoldebrand
How much impact on performance and disk space would this or set log_min_duration_statement=0 have? I have no idea as to how common this is, or when it happens, so it would need to run until this reported again (or some reasonable time if it doesn’t happen). /M. From: Andreas Joseph Krogh

Re: Transactions

2019-04-09 Thread Fabio Pardi
Hi Karl Martin, you could set log_min_duration_statement=0 at the global level (in the config file) or at session level too. regards, fabio pardi On 09/04/2019 11:26, Karl Martin Skoldebrand wrote: > Hi, > >   > > Is there a way to track “transactions” by default (i.e. without anyone