Postgres Pro
Downloads
Home   >   mailing lists

Re: altering a column's collation leaves an invalid foreign key - Mailing list pgsql-hackers

From Tom Lane
Subject Re: altering a column's collation leaves an invalid foreign key
Date
Msg-id 216627.1717791128@sss.pgh.pa.us
Whole thread Raw
In response to Re: altering a column's collation leaves an invalid foreign key  (jian he <jian.universality@gmail.com>)
Responses Re: altering a column's collation leaves an invalid foreign key
List pgsql-hackers
Tree view 
jian he <jian.universality@gmail.com> writes:
>> * in TryReuseForeignKey, we can pass the information that our primary
>> key old collation is nondeterministic
>> and old collation != new collation to the foreign key constraint.

I have a basic question about this: why are we allowing FKs to be
based on nondeterministic collations at all?  ISTM that that breaks
the assumption that there is exactly one referenced row for any
referencing row.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs
Next
From: Michael Paquier
Date:
Subject: Re: PgStat_KindInfo.named_on_disk not required in shared stats