#33901: non-deterministic collations doesn't work with Unique=True on
Postgres13.3
-------------------------------------+-------------------------------------
Reporter: Ed Chai | Owner: Ed Chai
Type: Bug | Status: closed
Component: Migrations | Version: dev
Severity: Normal | Resolution: fixed
Keywords: collation unique | Triage Stage: Ready for
citext | checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Ismael ABBO):
Hello everyone!
First thing first, I am a newbie, using 3.2 LTS (latest 3.2.16) version
and Postgres 14.4!
While this has been closed, I am still facing the same issue unless it is
just a patch for Django 4.2?
Please help on how to fix it!
Here is the error:
{{{
...
Applying auth.0012_alter_user_first_name_max_length... OK
Applying person.0001_initial...Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-
packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.FeatureNotSupported: nondeterministic collations are not
supported for operator class "varchar_pattern_ops"
The above exception was the direct cause of the following exception:
...
File "/usr/local/lib/python3.9/site-
packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.NotSupportedError: nondeterministic collations are not
supported for operator class "varchar_pattern_ops"
}}}
There is FeatureNotSupported error on psycopg2, I noticed but, if it is
the main reason, how was it managed before? Any workaround?
--
Ticket URL: <https://code.djangoproject.com/ticket/33901#comment:7>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/01070183ede7e8f4-f3c2dcee-38a3-447b-ab5c-6779601df9de-000000%40eu-central-1.amazonses.com.
