Handling UniqueViolationError for duplicate trace_id in SQLAlchemy with PostgreSQL AsyncPG
Hi, team I have errors with
syncpg.exceptions.UniqueViolationError: duplicate key value violates unique constraint "uq_traces_trace_id"
sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.IntegrityError: <class 'asyncpg.exceptions.UniqueViolationError'>: duplicate key value violates unique constraint "uq_traces_trace_id"
sqlalchemy.exc.IntegrityError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(sqlalchemy.dialects.postgresql.asyncpg.IntegrityError) <class 'asyncpg.exceptions.UniqueViolationError'>: duplicate key value violates unique constraint "uq_traces_trace_id"Is it normal aproach?
