On Mon, Dec 17, 2007 at 12:01:48PM +, Ronny Hellgren wrote:
>
> The following bug has been logged online:
>
> Bug reference: 3821
> Logged by: Ronny Hellgren
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.2
> Operating system: Windows XP
> Description:
Laurenz Albe wrote:
> Two concurrent sessions perform statements against one database. The
> sessions are named s1 and s2 in this example.
>
> s1=> CREATE TABLE x(i integer);
>
> s2=> BEGIN;
> s2=> CREATE UNIQUE INDEX x_pkey ON x(i);
>
> s1=> DROP TABLE x;
> (Session hangs)
>
> s2=> COMMIT;
>
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Hmm. So this is the bug that Tom mentioned on race conditions on
> pg_depend.
Yeah, I think it's a variant of the problem we've seen before:
http://archives.postgresql.org/pgsql-bugs/2007-03/msg00144.php
Still no nice ideas about how to fix it.
The following bug has been logged online:
Bug reference: 3833
Logged by: Laurenz Albe
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: RedHat Enterprise Linux 3
Description:Index remains when table is dropped
Details:
Two concurrent sessi