Postgres Pro
Downloads
Home   >   mailing lists

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

From Paul Jungwirth
Subject Re: altering a column's collation leaves an invalid foreign key
Date
Msg-id 69f0a887-a4ed-49cf-9d63-923891006658@illuminatedcomputing.com
Whole thread Raw
In response to altering a column's collation leaves an invalid foreign key  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: altering a column's collation leaves an invalid foreign key
List pgsql-hackers
Tree view 
On 3/23/24 10:04, Paul Jungwirth wrote:
> Perhaps if the previous collation was nondeterministic we should force a re-check.

Here is a patch implementing this. It was a bit more fuss than I expected, so maybe someone has a 
better way.

We have had nondeterministic collations since v12, so perhaps it is something to back-patch?

Yours,

-- 
Paul              ~{:-)
pj@illuminatedcomputing.com
Attachment

pgsql-hackers by date:

Previous
From: Donghang Lin
Date:
Subject: Re: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE
Next
From: Bharath Rupireddy
Date:
Subject: Re: Introduce XID age and inactive timeout based replication slot invalidation