Re: Open Transaction list

От:

Andrew Sullivan <andrew@libertyrms.info>

Дата:

21 августа 2003 г. в 12:06:25

On Wed, Aug 20, 2003 at 05:30:14PM -0400, Joseph Tate wrote:
> Is there a way to get a list of all the currently open transactions on a 
> database?

You can use the statistics in pg_stat_activity if you have the query
stats turned on. 

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
                              M2P 2A8
                                         +1 416 646 3304 x110

Open Transaction list

От:

Joseph Tate <jtate@nospam.mi-corporation.com>

Дата:

20 августа 2003 г. в 19:57:02

Is there a way to get a list of all the currently open transactions on a 
database?

Joseph