Admin has no support for unique constraint fields.

[Alex Urbanowicz]

The context is an Admin based application - all database operations are done using Admin. The backend is SQLite.
One of the fields in the application is a field for an (unique) ip address:

ip = models.GenericIPAddressField(protocol='IPv4', unique=True)

When there's an attempt to enter duplicate IP address, the application crashes to a 500 error:

django.db.utils.IntegrityError: UNIQUE constraint failed: <table>.ip

Attempt at handling that error by catching the exception and emitting an message leads to another error:

django.db.transaction.TransactionManagementError: An error occurred in the current transaction. You can't execute queries until the end of the 'atomic' block.

I would expect that, since the ORM supports unique fields, there's some Admin UI to handle constraint errors in a similar way to validation errors, and not fall flat and give the user a 500 error.

[Alex Urbanowicz]

s/append/attempt/

[Mariusz Felisiak]

Thanks for the report, however it works for me, see simplescreenrecorder-2023-03-01_19.13.17.mp4.