Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types
Date
Msg-id 202111012314.qcqulwshoxfx@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types  (Marcus Gartner <marcus@cockroachlabs.com>)
List pgsql-bugs
Tree view 
On 2021-Nov-01, Marcus Gartner wrote:

> I agree with you there. So why is an FK relationship between columns of
> different types even allowed?

It is useful in other cases, such as varchar or int4/int8.

Please don't top-post.

-- 
Álvaro Herrera              Valdivia, Chile  —  https://www.EnterpriseDB.com/
 Are you not unsure you want to delete Firefox?
       [Not unsure]     [Not not unsure]    [Cancel]
                   http://smylers.hates-software.com/2008/01/03/566e45b2.html

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #17261: FK ON UPDATE CASCADE can break referential integrity with columns of different types
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #17245: Index corruption involving deduplicated entries