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
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