Re: pg primary key bug?

On Tue, 2005-02-22 at 10:33 +0100, pginfo wrote:
> 
>   
> We are using  jdbc (jdbc driver from pg)  + jboss (java based
> application server) + connection pool (biult in jboss).
> ...
> Will vacuum full generate this problem if we have locked table in this
> time? (It is possible to have locked table in theory)

I do not know if this is relevant, but I have seen jboss applications
keep sessions in 'Idle in transaction' state, apparently with some
locks granted. Would such cases not interfere with vacuum?

gnari