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
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