My initial concern was around the minimum PostgreSQL version that Django
5.0 will support. According to
https://en.wikipedia.org/wiki/PostgreSQL#Release_history , PostgreSQL 10 is
supported until 2022-11-10 , and version 11 until 2023-11-09. With Django
5.0 expected in 2024-01, it should be fine to deprecate the CI fields for
removal in Django 5.0. Users on old PostgreSQL versions can manage the
deprecation warning until they upgrade.

So +1 from me.

On Tue, 25 Jan 2022 at 12:39, Mariusz Felisiak <felisiak.mari...@gmail.com>
wrote:

> Hi y'all,
>
>     Django 3.2+ supports "db_collation" [1] for "CharField" and
> "TextField" along with migration operations ("CreateCollation()",
> "RemoveCollation") and the database function "Collate()" [3]. Moreover CI
> fields and the entire "citext" module are discouraged since PostgreSQL 12
> [4] in favor of collations. I think it's time to deprecate CI fields from
> the "contrib.postgres" in favor of "CharField" and "TextField" with case
> insensitive collations (and remove them in Django 5.0).
>
> Best,
> Mariusz
>
> [1] https://code.djangoproject.com/ticket/31777
> [2] https://code.djangoproject.com/ticket/32046
> [3] https://code.djangoproject.com/ticket/21181
> [4] https://www.postgresql.org/docs/12/citext.html
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django developers (Contributions to Django itself)" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-developers+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-developers/833bb13b-3db1-f35b-3d51-a2a4671b45a9%40gmail.com
> <https://groups.google.com/d/msgid/django-developers/833bb13b-3db1-f35b-3d51-a2a4671b45a9%40gmail.com?utm_medium=email&utm_source=footer>
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django developers  (Contributions to Django itself)" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-developers+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-developers/CAMyDDM1woKitn3cd7CQ%3DYLuPcHuR_U0vATScjdQLvsvC7JtWEQ%40mail.gmail.com.
  • D... Mariusz Felisiak
    • ... 'Adam Johnson' via Django developers (Contributions to Django itself)
      • ... Mariusz Felisiak
        • ... Mariusz Felisiak
          • ... Mariusz Felisiak
            • ... Silvio
              • ... Mariusz Felisiak
                • ... 'Johannes Maron' via Django developers (Contributions to Django itself)
                • ... Mariusz Felisiak
                • ... Tom Carrick
                • ... 'Adam Johnson' via Django developers (Contributions to Django itself)
                • ... 'Johannes Maron' via Django developers (Contributions to Django itself)

Reply via email to