"James B. Byrne" <byrnejb(at)harte-lyne(dot)ca> writes:
> I am testing the trigger function that I wrote. Is there a way to
> increase the logging detail level for just a single database
> instance?
ALTER DATABASE foo SET log_min_messages = whatever;
Note this will only affect subsequently-started sessions. Also,
if memory serves, you have to be superuser to set this particular
variable.
regards, tom lane