citusdata / django-multitenant

Python/Django support for distributed multi-tenant databases like Postgres+Citus
MIT License
707 stars 116 forks source link

The explicit NULL column constraint is not working in Citus 12 #195

Open pbav opened 10 months ago

pbav commented 10 months ago
ALTER TABLE a ADD COLUMN b INT NULL;
[2023-08-11 11:53:30] [XX000] ERROR: unsupported constraint type
[2023-08-11 11:53:30] Detail: constraint type: 0

Details: https://github.com/citusdata/citus/issues/7110

Please consider including a workaround

# django_multitenant/backends/postgresql/base.py
class TenantDatabaseFeatures(PostgresqlDatabaseFeatures):
    implied_column_null = True

in django-multitenant project.