Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id DB48012FE952 for ; Thu, 5 Apr 2012 21:19:24 -0300 (ADT) Received: from mail-qa0-f53.google.com ([209.85.216.53]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SFwtf-0007Or-9I for pgsql-hackers@postgresql.org; Fri, 06 Apr 2012 00:19:24 +0000 Received: by qadc11 with SMTP id c11so103894qad.19 for ; Thu, 05 Apr 2012 17:19:10 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=date:from:to:cc:subject:message-id:references:mime-version :content-type:content-disposition:in-reply-to:user-agent :x-gm-message-state; bh=D8BQhdJyGEvRZyQskX3NywDvkJunO5H98XsSExY9a44=; b=lk9qvyql30ASN69u3wA1ycGVGHRsNQ0mZLHKTI4iz9cAR0BpQ5v7kI4iIn1dko/Y5V GWLEUACnMTEMDVN/Uj60b/dFRtY1/FT4Yv1XzlJ3q8eSu3ZVMVWrjXGLhDgKLxyRqsMz CtllT2Lfch/sjYNQXBcQru78QX9mUmJGUBtIoMu7fifa+orlwWcJM+HRcyiCQs1Zhr7Z nRpWFhCXrwgSdf1J4Yf8GbNok4ws2sSR5p+WoXFV9Fse8vka6E0a3NyM1ly/Hc1IFGXP 1JmH1Cx6wzydyhDfpYiguX60ZQ7amv6zyTsumc2DTLtzKAQDYoAdhZKxIS6N5PWcqXkJ d8Fw== Received: by 10.224.31.197 with SMTP id z5mr6926902qac.26.1333671550574; Thu, 05 Apr 2012 17:19:10 -0700 (PDT) Received: from tornado.leadboat.com (ip68-105-236-221.hr.hr.cox.net. [68.105.236.221]) by mx.google.com with ESMTPS id ha3sm8485768qab.13.2012.04.05.17.19.09 (version=SSLv3 cipher=OTHER); Thu, 05 Apr 2012 17:19:09 -0700 (PDT) Date: Thu, 5 Apr 2012 20:19:07 -0400 From: Noah Misch To: Robert Haas Cc: Tom Lane , Simon Riggs , PostgreSQL-development Subject: Re: Last gasp Message-ID: <20120406001907.GB4451@tornado.leadboat.com> References: <23175.1333650183@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.18 (2008-05-17) X-Gm-Message-State: ALoCoQkI9trryJ9n02btqf4rbVMCUDGVTXdLQsvaJOdjz8caLEAC9hgoRhEiEVhnQYRzJYSNLJ7V X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201204/291 X-Sequence-Number: 206094 On Thu, Apr 05, 2012 at 02:34:30PM -0400, Robert Haas wrote: > On Thu, Apr 5, 2012 at 2:23 PM, Tom Lane wrote: > > The FK arrays one I'm kind of queasy about. ?It's a cool-sounding idea > > but I'm not convinced that all the corner-case details have been > > adequately thought through, and I'm scared of being unable to fix any > > such bugs in later versions because of backwards compatibility worries. > > It'd be a lot better to be pushing this in at the start of a devel cycle > > than the end. > > I've been feeling that that patch has been suffering from a lack of > reviewer attention, which is a real shame, because I think the > functionality is indeed really cool. But I haven't looked at it > enough to know what kind of shape it's in. As the reviewer, I'm not aware of any unexplored corner cases or problems that ought to preclude commit. That said, it is a large patch; I doubt anyone could pick it up from scratch and commit it with less than a solid day's effort, and 2-3 days might be more likely. In retrospect, I should have suggested splitting the new ON DELETE/ON UPDATE actions into their own patch. That would have nicely slimmed the base patch and also isolated it from the ON DELETE EACH CASCADE judgement call.