Vivek Khera wrote:
I want to do some debugging on an app, and I'd like to set on a per-connection basis "set log_min_duration_statement = 10;" Obviously since I'm not super user I get permission denied.

Is there some GRANT I can grant to the user in question to allow this? I don't really want to do it globally or for all connections by that user, both of which are easy to do

Could you handle it with a security=definer function?

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/

Reply via email to