From: Peter Eisentraut <peter@eisentraut.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add tests for foreign keys with case-insensitive collations
Date: Fri, 29 Nov 2024 07:59:11 +0000
Message-ID: <E1tGvuB-0007o8-B1@gemulon.postgresql.org> (raw)
Add tests for foreign keys with case-insensitive collations
Some of the behaviors of the different referential actions, such as
the difference between NO ACTION and RESTRICT are best illustrated
using a case-insensitive collation. So add some tests for that.
(What is actually being tested here is the behavior with values that
are "distinct" (binary different) but compare as equal. Another way
to do that would be with positive and negative zeroes with float
types. But this way seems nicer and more flexible.)
Discussion: https://www.postgresql.org/message-id/ea5b2777-266a-46fa-852f-6fca6ec480ad@eisentraut.org
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/4a2dbfc6be45c4ce2d9ac53502f931e6b1d70318
Modified Files
--------------
src/test/regress/expected/collate.icu.utf8.out | 62 ++++++++++++++++++++++++++
src/test/regress/sql/collate.icu.utf8.sql | 30 +++++++++++++
2 files changed, 92 insertions(+)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: peter@eisentraut.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add tests for foreign keys with case-insensitive collations
In-Reply-To: <E1tGvuB-0007o8-B1@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox