Foreign key data type mismatches - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Foreign key data type mismatches
Date
Msg-id Pine.LNX.4.44.0312011301420.23215-100000@peter.localdomain
Whole thread Raw
Responses Re: Foreign key data type mismatches  (Andreas Pflug <pgadmin@pse-consulting.de>)
Re: Foreign key data type mismatches  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-hackers
I was just annoyed to find out that a foreign key doesn't check whether
the referenced column has a sufficiently similar data type, it only checks
whether an = operator exists.  This masks schema design errors and typos.
Should this be tightened up, for example using the castability
characteristics between the two data types?

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: "phd9110"
Date:
Subject: Where does catalog store CHAR length ?
Next
From: Andreas Pflug
Date:
Subject: Re: Foreign key data type mismatches