Rather than count the number of connections which would be prone
to failure due to race conditions, you should do this instead:
BEGIN EXCLUSIVE;
-- run whatever SQL statements you want here,
-- or copy the database file.
COMMIT;
Just schedule this job off-hours when people are not likely using the
database.
--- Chase <[EMAIL PROTECTED]> wrote:
> is there any way (in c/c++) to find out how many current connections
> there are to a database that i am connected to?
>
> i'd like to do some housekeeping on the database every so often, but
> only if there's no one else connected to it at the time.
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the
tools to get online.
http://smallbusiness.yahoo.com/webhosting
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
