Re: FOR KEY LOCK foreign keys

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <noah(at)2ndQuadrant(dot)com>,<alvherre(at)commandprompt(dot)com>
Cc: <dimitri(at)2ndquadrant(dot)fr>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: FOR KEY LOCK foreign keys
Date: 2011-07-16 18:03:31
Message-ID: 4E218C23020000250003F414@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Noah Misch wrote:

> With this patch in its final form, I have completed 180+ suite runs
> without a failure.

The attached patch allows the tests to pass when
default_transaction_isolation is stricter than 'read committed'.
This is a slight change from the previously posted version of the
files (because of a change in the order of statements, based on the
timeouts), and in patch form this time.

Since `make installcheck-world` works at all isolation level
defaults, as do all previously included isolation tests, it seems
like a good idea to keep this up. It will simplify my testing of SSI
changes, anyway.

-Kevin

Attachment Content-Type Size
fklocks-tests-strict-isolation.patch application/octet-stream 11.3 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2011-07-16 18:07:51 Re: SSI error messages
Previous Message Noah Misch 2011-07-16 17:25:03 Re: isolation test deadlocking on buildfarm member coypu