Re: Fix optimization of foreign-key on update actions - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Fix optimization of foreign-key on update actions
Date
Msg-id 8b911478-9c6e-9062-6d2c-654e4bfb570c@2ndquadrant.com
Whole thread Raw
In response to Re: Fix optimization of foreign-key on update actions  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: Fix optimization of foreign-key on update actions
List pgsql-hackers
On 2019-02-06 23:15, Peter Eisentraut wrote:
> On 05/02/2019 17:20, Tom Lane wrote:
>> What I *don't* like about the proposed patch is that it installs a
>> new, different comparison rule for the ON UPDATE CASCADE case only.
>> If we were to go in this direction, I'd think we should try to use
>> the same comparison rule for all FK row comparisons.
> 
> That's easy to change.  I had it like that in earlier versions of the
> patch.  I agree it would be better for consistency, but it would create
> some cases where we do unnecessary extra work.

Updated patch with this change made, and some conflicts resolved.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Fix volatile vs. pointer confusion
Next
From: Dean Rasheed
Date:
Subject: Re: [Patch] Log10 and hyperbolic functions for SQL:2016 compliance