[GENERAL] Question about pg_stat_activity

Hi, When I run the following on my server: SELECT * FROM pg_stat_activity I get back command string not enabled for the field current_query. I have stats enabled in my config file, is there some other setting that I missed so I can see the current query? I also thought that in 7.x it would say

Re: [GENERAL] Question about pg_stat_activity

On Wed, Jan 12, 2005 at 11:57:18PM -0600, Tony Caduto wrote: When I run the following on my server: SELECT * FROM pg_stat_activity I get back command string not enabled for the field current_query. I have stats enabled in my config file, is there some other setting that I missed so I

Re: [GENERAL] Question about pg_stat_activity

Hi, I have it working now, I must have missed the stats_command_string setting in the conf file. Thanks, Tony Michael Fuhr wrote: On Wed, Jan 12, 2005 at 11:57:18PM -0600, Tony Caduto wrote: When I run the following on my server: SELECT * FROM pg_stat_activity I get back command string not