Horton

Re: altering a column's collation leaves an invalid foreign key

Marcos Pegoraro <marcos@f10.com.br>

View thread View on postgr.es
From: Marcos Pegoraro <marcos@f10.com.br>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: jian he <jian.universality@gmail.com>, Paul Jungwirth <pj@illuminatedcomputing.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-11-29T14:25:57Z
Lists: pgsql-hackers 
Em ter., 19 de nov. de 2024 às 13:27, Peter Eisentraut <peter@eisentraut.org>
escreveu:

> 3. Some documentation updates to explain some of the differences between
> NO ACTION and RESTRICT better.
>

There is a typo on your commit "doc: Improve description of referential
actions"

There is also a noticeable difference between <literal>ON UPDATE NO
+    ACTION</literal> (the default) and <literal>NO UPDATE
RESTRICT</literal>.

Should be ON UPDATE RESTRICT, right ?

Commits

  1. Fix error code for referential action RESTRICT

  2. doc: Improve description of referential actions

  3. Add tests for foreign keys with case-insensitive collations

  4. Fix collation handling for foreign keys

  5. Clarify a foreign key error message