#36598: Django migrations is unable to find remove constraints from non-public
schema for Postgres
-------------------------------------+-------------------------------------
Reporter: Salaah Amin | Owner: (none)
Type: Bug | Status: new
Component: Database layer | Version: 4.2
(models, ORM) |
Severity: Normal | Resolution:
Keywords: postgres, db, orm | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Tanishq):
Hi Salaah,
I’ve looked into the problem with migrations failing to remove constraints
from the {{{analytics.occupancy}}}table in a non-public schema, and it
seems related
to
{{{django.db.backends.postgresql.introspection.DatabaseIntrospection.get_constraints}}}
not detecting constraints due to
the{{{pg_catalog.pg_table_is_visible(cl.oid)}}}filter, despite
the{{{search_path=public,analytics}}}setting
in{{{DATABASES["OPTIONS"]}}}.The{{{ValueError: Found wrong number (0) of
constraints}}}suggests that the introspection query isn’t picking up
schema-qualified constraints during removal operations. This could be a
bug or a missing feature, as creation works fine. A potential fix might
involve modifying {{{get_constraints}}}to either:
Use the schema from{{{db_table}}}(e.g., "{{{analytics"."occupancy}}}")
explicitly in the query, or Adjust the SQL to include the schema in the
{{{JOIN}}} condition, bypassing the visibility filter when the schema is
specified.
--
Ticket URL: <https://code.djangoproject.com/ticket/36598#comment:2>
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 django-updates+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/django-updates/0107019939b0337d-ffcf03c1-e94c-46d9-bd40-b4e54b43e3c4-000000%40eu-central-1.amazonses.com.
