[BUGS] BUG #1459: Connection hangs when other connection is not committed

2005-02-03 Thread Rainer Frey
The following bug has been logged online: Bug reference: 1459 Logged by: Rainer Frey Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Redhat Linux 9, Kernel 2.4.20-8, AMD Sempron 2500+, 1GB RAM Description:Connection hangs when other

Re: [BUGS] BUG #1459: Connection hangs when other connection is not

2005-02-07 Thread Rainer Frey
Peter Eisentraut schrieb: Am Donnerstag, 3. Februar 2005 16:11 schrieb Rainer Frey: A select should not lock a table even when it is not committed. The SELECT obtains a read (shared) lock on the table, but the ALTER TABLE requires a write (exclusive) lock. This is certainly necessary because