select count(*) from pg_stat_activity in V8.0.0 - Mailing list pgsql-general

From Anony Mous
Subject select count(*) from pg_stat_activity in V8.0.0
Date
Msg-id 005501c485ba$3d5f6610$6902a8c0@PETER
Whole thread Raw
Responses Re: select count(*) from pg_stat_activity in V8.0.0  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Coming off of 7.4.3 I've always used

select count(*) from pg_stat_activity

through the ODBC driver to obtain the number of connections to the db.  I've
found that with v8.0 Beta 1 that this at times has returned a value of 0
(when there is obviously still a connection).  It's not repeatable, and
occurs sporadically.  Does anyone have any reason as to why this would be
isolated to V8?  Is this an acceptable means of obtaining the number of
connection to the database in V8 (via ODBC).

Thanks so much,
Peter


pgsql-general by date:

Previous
From: "yateen joshi"
Date:
Subject: Vacuum, per table or entire database? what is better?
Next
From: Shridhar Daithankar
Date:
Subject: Re: Postgresql feature