Tag Info

New answers tagged

1

You were close. Your last idea is actually the way to go: log_statement = none log_min_duration_statement = 10000 Then no statement will be logged, except those running longer than 10 seconds - including the query string itself. Logging may have seemed to stop because 10 seconds is a high threshold. I am using 2 seconds normally, but YMMV. This related ...


0

Your regexp_replace() statement is invalid. It would work like this: SELECT regexp_replace(tbl, '('''')$', '' , 'g') FROM ( VALUES ('6''''') ,('6''''') ,('6''''') ,('20''''') ,('12''''') ,('18''''') ,('20''''') ,('8''''') ,('10''''') ,('''''') ,('''''') ) tbl(tbl) Your SELECT INTO statement is invalid. It would look like this: SELECT ...


0

In this particular situation what did help me: It was needed just to copy extension directory from /usr/share/pgsql/extension/ to /var/lib/pgsql-root/usr/lib/pgsql/extension/. That's all folks.



Top 50 recent answers are included