It seems that the related DETAIL message appears if the query is successful. On error the DETAIL log line is missing... This makes debugging difficult, considering the insert is coming from Dreamfactory via a rest POST.
I am finding it very difficult navigating my way through the brave new world of SAS and Blackbox type applications.... Maybe 32 years as a database programmer is just too long.
On 06/12/2018 08:25 PM, David G. Johnston wrote: > On Tuesday, June 12, 2018, Andrew Bartley <ambartley@gmail.com > <mailto:ambartley@gmail.com>> wrote: > > > > On Wed, 13 Jun 2018 at 12:43 Laurenz Albe <laurenz.albe@cybertec.at > <mailto:laurenz.albe@cybertec.at>> wrote: > > > log_min_duration_statement = 0 > > [...] > > > log_min_duration_statement -1 > > > You've disabled statement logging altogether. The zero value you were > directed to use is what causes everything to be logged.
"... Setting this to zero prints all statement durations. Minus-one (the default) disables logging statement durations. ..."
"
So -1 only affects logging statements relative to duration.
If you have log_statements set then you will still get statements logged if you have log_min_duration_statement = -1 :
Note
When using this option together with log_statement, the text of statements that are logged because of log_statement will not be repeated in the duration log message. "
This is how I have my logging setup, log_min_duration_statement = -1 and log_statements = 'mod' and I see statements in the logs.
