Re: [BUGS] BUG #6101: ALTER TABLE hangs with AccessExclusiveLock

2011-07-09 Thread Craig Ringer
On 9/07/2011 4:05 PM, Dmitriy Savricov wrote: As i figured out, the reason is in " in transaction" process, which hangs after table filling. From yestaday, I could not understand what the process keeps the lock, and thinked that reason was inside FTS - from system tables (pg_class) it was imposs

Re: [BUGS] BUG #6101: ALTER TABLE hangs with AccessExclusiveLock

2011-07-08 Thread Craig Ringer
On 8/07/2011 7:33 PM, Dmitry wrote: The following bug has been logged online: Bug reference: 6101 Logged by: Dmitry Email address: y4gr5...@gmail.com PostgreSQL version: 9.0.4 Operating system: Debian i686 2.6.32-5-686-bigmem Description:ALTER TABLE hangs with Access