On Tue, Jun 17, 2008 at 06:49:57AM +0000, Clemens Wagner wrote: > I have sometimes hanging psql backend processes with "idle in transaction"
There is no bug here. Some transaction is stuck waiting for something else, or else you've left a transaction hanging around that way (is your JDBC driver old? It used to issue BEGIN right after COMMIT when in non-autocommit mode. That'd cause this issue). You need to figure out what's blocking what. Look in the pg_locks system view. See the manual for more on this. > high traffic on the database. It leads sometimes to an inconsisten database > with double primary keys in a table or a broken unique indexes ( > "pg_statistic_relid_att_index" for instance). I can't enforce this error. I don't believe this is the problem you're having there. If what you're saying is the case, you need to look for breakage elsewhere. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
