v2.0.4rc1

Changes since v2.0.3

• Remove default_app_config for Django 3.2 and newer
• Allow wider range of pyscopgy2 versions
• Fixed typo's and syntax errors in docs
  • Fix broken references to psqlextra.migrations.operations in docs
  • Fix typo in indexes docs example
  • Fix syntax error in installation docs
  • Fix RST formatting typo in installation docs
• Support for hash partioning
• Skip partioning tests on Postgres 10
• Python 3.10 support
• Django 3.2 support
• Fix #149: PostgresRangePartitioningStrategy should derive from PostgresPartitioningStrategy

pip install django-postgres-extra==2.0.4rc1

https://pypi.python.org/pypi/django-postgres-extra/2.0.4rc1

v2.0.3

Changes since v2.0.3rc3

• Relax structlog requirement to allow structlog v22

pip install django-postgres-extra==2.0.3

https://pypi.python.org/pypi/django-postgres-extra/2.0.3

v2.0.3rc3

Changes since v2.0.3rc2

• Allow Q objects to be used for upsert condition
• Add UniqueIndex for materialized views

pip install django-postgres-extra==2.0.3rc3

https://pypi.python.org/pypi/django-postgres-extra/2.0.3rc3

v2.0.3rc2

Changes since v2.0.3rc1

• Use OrderedDict for renamed annotations
• Support for conditions in upserts

pip install django-postgres-extra==2.0.3rc2

https://pypi.python.org/pypi/django-postgres-extra/2.0.3rc2

v2.0.3rc1

Changes since v2.0.2

• Fix regression that broke annotations

pip install django-postgres-extra==2.0.3rc1

https://pypi.python.org/pypi/django-postgres-extra/2.0.3rc1

v2.0.2

Changes since v2.0.1

• Make AddRangePartition operation reversible
• Make AddListPartition operation reversible

pip install django-postgres-extra==2.0.2

https://pypi.python.org/pypi/django-postgres-extra/2.0.2

v2.0.1

Changes since v2.0

• Allow psqlextra.backend to be configured for a non-default connection/db.
• Maintain annotation order during renames

pip install django-postgres-extra==2.0.1

https://pypi.python.org/pypi/django-postgres-extra/2.0.1

v2.0

Changes since v1.22

See also: https://django-postgres-extra.readthedocs.io/en/master/major_releases.html#id1

New features

• Support for PostgreSQL 11.x declarative table partitioning.
• Support for TRUNCATE TABLE
• Case insensitive index
• Support for Django 3.x
• Support for Python 3.8 and 3.9

Other changes

• Uses Django 2.x's mechanism for overriding queries and compilers. django-postgres-extra is extensible in the same way that Django is extensible now.
• Removes hacks because Django 2.x is more extensible.

Breaking changes

• Removes support for psqlextra.signals. Switch to standard Django signals.
• Inserts with ConflictAction.NOTHING only returns new rows. Conflicting rows are not returned.
• Drop support for Python 3.5.
• Drop support for Django 1.x.
• Removes psqlextra.expressions.Min, psqlextra.expressions.Max, these are natively supported by Django.

pip install django-postgres-extra==2.0

https://pypi.python.org/pypi/django-postgres-extra/2.0

v1.22

Changes since v1.21

• #35 Django 2.0 compatibility
• #46 Foreign keys as objects
• #41 Foreign keys that are primary keys
• #49 Support for index_predicate in all shortcut methods and bulk upsert
• #52 bulk_upsert should return objects upserted
• Experimental support for expressions in HStore values.
• Fixed an bug in experimental HStore expression support that would cause ambiguity between keys and values.
• #57 Fixes a bug that makes PostgresQuerySet.insert properly return the primary key instead of assuming the primary key is always a single column named id. (fixes #48)
• Fixes a bug that broke string casting for values inside a HStoreValue (dict(key1=1) should become dict(key1='1')).
• Fixes a bug that causes an error when upgrading from an older version of django-postgres-extra from before "required constraints" were enforced on a DB level. It would attempt to drop a non-existent constraint.
• Fix broken backwards compatibility with Django 1.11X, add support for Django 2.1
• Fix renaming annotations not working with Django 2.1
• #71 Deconstruct empty list of required and uniqueness keyword arguments
• #79 Ensure bulk_upsert always returns an iterable
• #78 Add return_model to bulk_upsert
• #83 Ensure bulk_upsert accepts any iterable for rows

pip install django-postgres-extra==1.22

https://pypi.python.org/pypi/django-postgres-extra/1.22

v1.21a18

Changes

• #83 Ensure bulk_upsert accepts any iterable for rows

pip install django-postgres-extra==1.21a18

https://pypi.python.org/pypi/django-postgres-extra/1.21a18

Alpha

Note, this is an alpha release.