X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1A84852B87 for ; Thu, 11 Aug 2005 20:30:45 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54180-07 for ; Thu, 11 Aug 2005 23:30:40 +0000 (GMT) Received: from sccmmhc91.asp.att.net (sccmmhc91.asp.att.net [204.127.203.211]) by svr1.postgresql.org (Postfix) with ESMTP id E6DE552822 for ; Thu, 11 Aug 2005 20:30:36 -0300 (ADT) Received: from juju.arbash-meinel.com ([12.214.18.81]) by sccmmhc91.asp.att.net (sccmmhc91) with ESMTP id <20050811233036m9100g7hq6e>; Thu, 11 Aug 2005 23:30:36 +0000 Received: by juju.arbash-meinel.com (Postfix, from userid 505) id 41E2056008; Thu, 11 Aug 2005 18:30:36 -0500 (CDT) Received: from [192.168.1.12] (Jigglypuff.arbash-meinel.com [192.168.1.12]) by juju.arbash-meinel.com (Postfix) with ESMTP id BFBF355FCC; Thu, 11 Aug 2005 18:30:29 -0500 (CDT) Message-ID: <42FBDF94.5060104@arbash-meinel.com> Date: Thu, 11 Aug 2005 18:30:28 -0500 From: John A Meinel User-Agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alvaro Herrera Cc: Postgresql Performance Subject: Re: Odd Locking Problem References: <42FBB6CF.6000404@arbash-meinel.com> <20050811210842.GA28253@alvh.no-ip.org> In-Reply-To: <20050811210842.GA28253@alvh.no-ip.org> X-Enigmail-Version: 0.92.0.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigA572A149154C7AAEB8BE044E" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.044 tagged_above=0 required=5 tests=[AWL=-0.006, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/137 X-Sequence-Number: 13884 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigA572A149154C7AAEB8BE044E Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Alvaro Herrera wrote: > On Thu, Aug 11, 2005 at 03:36:31PM -0500, John A Meinel wrote: > ... > > This is a known problem, solved in 8.1. A workaround for previous > releases is to defer FK checks until commit: So I don't know exactly what the fix was, but I just tested, and my problem is indeed fixed with the latest CVS head. It no longer blocks. > > create table b (a int references a initially deferred); > John =:-> --------------enigA572A149154C7AAEB8BE044E Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (Darwin) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFC+9+UJdeBCYSNAAMRAmrrAJ4xvUnHizNwntKnQvWdUeFoXJvsgACgrH3a xypks5LPA/BuZ3T9h2oZlpo= =b9YD -----END PGP SIGNATURE----- --------------enigA572A149154C7AAEB8BE044E--