Re: [HACKERS] Weird idea for pg_stat_activity

2006-08-15 Thread Josh Berkus
Bruce, > Wouldn't it be weird if an update to pg_stat_activity.current_query > actually ran that query for the selected backend: Wierd? Yes. Useful? No. -- Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 2: Don't 'kill

Re: [HACKERS] Weird idea for pg_stat_activity

2006-08-15 Thread Jim C. Nasby
On Tue, Aug 15, 2006 at 01:29:02AM -0400, Bruce Momjian wrote: > Wouldn't it be weird if an update to pg_stat_activity.current_query > actually ran that query for the selected backend: > > UPDATE pg_stat_activity SET current_query = "SELECT 1" > WHERE procpid = 19522; Interesting thou