Re: [GENERAL] DDL DML Logging doesn't work for calling functions

2011-11-30 Thread Albe Laurenz
MURAT KOÇ wrote: Version is PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit. We set logging parameters as below for DDL DML Logging: logging_collector = on log_statement = mod log_line_prefix =

Re: [GENERAL] DDL DML Logging doesn't work for calling functions

2011-11-30 Thread MURAT KOÇ
Thanks for reply. If we set log_statement='all', all of sql statements will be logged and log file will grow up immediately (also including unnecessary sql statements). We don't want all sql statements to be logged, so we continue logging settings as my previous sending (log_statement = 'mod').

Re: [GENERAL] DDL DML Logging doesn't work for calling functions

2011-11-30 Thread Albe Laurenz
MURAT KOÇ wrote: If we set log_statement='all', all of sql statements will be logged and log file will grow up immediately (also including unnecessary sql statements). We don't want all sql statements to be logged, so we continue logging settings as my previous sending (log_statement =

[GENERAL] DDL DML Logging doesn't work for calling functions

2011-11-29 Thread MURAT KOÇ
Hi list, Version is PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 64-bit. We set logging parameters as below for DDL DML Logging: logging_collector = on log_statement = mod log_line_prefix = '%t--%d--%u--%h--%a--%i--%e' Server log