Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 215EE2E00AA for ; Wed, 12 Dec 2007 13:40:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87193-03 for ; Wed, 12 Dec 2007 13:40:36 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by postgresql.org (Postfix) with ESMTP id 51C672E00A8 for ; Wed, 12 Dec 2007 13:40:35 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so559240waf.5 for ; Wed, 12 Dec 2007 09:40:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=OEC4C3DRbMbwRFlwKSKaygYuuU7u50s2WLj+7dbbzSo=; b=D0KM0362MjaPWNu5cSICBm1/1RmdQxt1PQFUGmLJKF2QC95mcbCyyHALnt3Xo12PhTy4cebfen7BrLKjgp5/z7lwE9zYuvxqvdmr7U3uLp5ZP0RZM0HOdJF5j3ODJreSsi2Il/xBxRO6IGdMkEl4SYbjnk8m2J4xLoqoiX8wZ3U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=HQ2UcM3xYdCNnG8Qsa21Ht98CShpofnU1wHL2aCStxO7b1lFrX9/G1EKdBfuElAG9Tc65VAnYI4RUIP2N2oJ1U1Uc3S1JC8upswhGoO7jca4UIwpH6JBZyiuaJLiiDjBBfmCRdMvcNtZ2YRWGPa/OcoL97eGoXghUFEDA+obfu4= Received: by 10.114.157.1 with SMTP id f1mr1093181wae.13.1197481233193; Wed, 12 Dec 2007 09:40:33 -0800 (PST) Received: by 10.114.199.9 with HTTP; Wed, 12 Dec 2007 09:40:33 -0800 (PST) Message-ID: <4544e0330712120940i413e3ad6y867fc2a8744f623b@mail.gmail.com> Date: Wed, 12 Dec 2007 11:40:33 -0600 From: "Peter Koczan" To: "Tom Lane" Subject: Re: Legacy foreign keys Cc: "Alvaro Herrera" , pgsql-admin@postgresql.org In-Reply-To: <10859.1197428770@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4544e0330712101112r6aeccfcckef378a7ea1795e07@mail.gmail.com> <20071210195046.GE27126@alvh.no-ip.org> <20427.1197324492@sss.pgh.pa.us> <4544e0330712111901k1fa50c5dgb26287aff018e98c@mail.gmail.com> <10859.1197428770@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/70 X-Sequence-Number: 27587 On Dec 11, 2007 9:06 PM, Tom Lane wrote: > "Peter Koczan" writes: > >> No, pg_dump isn't involved --- the new smarts are inside the server, > >> in CREATE CONSTRAINT TRIGGER. It sounds like Peter has a case that is > >> confusing that new code. Could we see a complete example? > > > Sure, here's the command: > > [ squint... ] Which 8.3beta are you testing, exactly? This was dealt > with in beta3. > > If it is beta3 or later, please send the output of "pg_dump -s -t wspolicy" > from the 8.2 database. *lightbulb* beta2. I haven't had much time to dedicate to testing new betas yet (I was just trying to get a test 8.3 server up and running), but I will do so. Thanks. Peter