Re: Check for non-deterministic FK collations before upgrade - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Check for non-deterministic FK collations before upgrade
Date
Msg-id CD8E779F-7EE4-409D-9FDB-9B16DD324893@yandex-team.ru
Whole thread
In response to Check for non-deterministic FK collations before upgrade  (Kirill Reshke <reshkekirill@gmail.com>)
List pgsql-hackers
Hi Kirill,

I think this is a useful pre-upgrade check.

> or by removing the constraint and recreating it after the
> upgrade.

Recreating the same FK after upgrade still fails, even with NOT VALID.
Could we remove that alternative, or clarify that the collations still
need to be made compatible?

Maybe the successful test could keep FKs with identical nondeterministic
collations and with different deterministic collations? Currently it has
no FK left, so rejecting all collated FKs would also pass the test.

Thank you!


Best regards, Andrey Borodin.




pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: parallel autovacuum: Propagate track_cost_delay_timing to parallel workers
Next
From: Jakub Wartak
Date:
Subject: Re: doc: Document Linux cgroup memory limits