Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id A5F1C126090C for ; Wed, 27 Jun 2012 12:27:50 -0300 (ADT) Received: from 30.55.colo.spiretech.net ([69.168.55.30] helo=lists.commandprompt.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Sju9L-0000DX-Fc for pgsql-hackers@postgresql.org; Wed, 27 Jun 2012 15:27:26 +0000 Received: from perhan.alvh.no-ip.org (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id B5C53287; Wed, 27 Jun 2012 08:27:08 -0700 (PDT) Received: from perhan.alvh.no-ip.org ([190.95.9.148] helo=perhan.alvh.no-ip.org) by assp.commandprompt.com with ESMTPS(AES256-SHA) (2.1.1); 27 Jun 2012 08:27:05 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 55A086E4A0; Wed, 27 Jun 2012 11:27:03 -0400 (CLT) Content-Type: text/plain; charset=UTF-8 Cc: Pg Hackers Subject: Re: foreign key locks From: Alvaro Herrera To: Kevin Grittner In-reply-to: <4FEAB90A0200002500048B7D@gw.wicourts.gov> References: <4FEAB90A0200002500048B7D@gw.wicourts.gov> Date: Wed, 27 Jun 2012 11:27:03 -0400 Message-Id: <1340810619-sup-9293@alvh.no-ip.org> User-Agent: Sup/git X-Assp-Version: 2.1.1(11364) on assp.commandprompt.com X-Assp-Client-TLS: yes X-Assp-ID: assp.commandprompt.com m1-10828-04443 X-Assp-Envelope-From: alvherre@alvh.no-ip.org X-Assp-Intended-For: pgsql-hackers@postgresql.org X-Assp-Original-Subject: Re: [HACKERS] foreign key locks Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/1651 X-Sequence-Number: 210491 Excerpts from Kevin Grittner's message of mi=C3=A9 jun 27 08:40:58 -0400 = 2012: > Alvaro Herrera wrote: > =20 > > here's fklocks v14, which also merges to new master as there were > > several other conflicts. It passes make installcheck-world now. > =20 > Recent commits broke it again, so here's a rebased v15. (No changes > other than attempting to merge your work with the pg_controldata and > pg_resetxlog changes and wrapping that FIXME in a comment.) Oooh, so sorry -- I was supposed to have git-stashed that before producing the patch. This change cannot have caused the pg_dumpall problem below though, because it only touched the multixact cache code. > Using that patch, pg_upgrade completes, but pg_dumpall fails: Hmm, something changed enough that requires more than just a code merge. I'll look into it. Thanks for the merge. --=20 =C3=81lvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support