Postgres in docker: random «unique violation» errors

• 10, 12, 2019
•  bullgare
•  Databases
• No Comments.

While running postgres in docker (for development, of course), from time to time I just run into errors like «Duplicate Key Value Violates Unique Constraint».
I found the solution (thanks to this answer, for sure — https://stackoverflow.com/a/47089825/801426):
if you have a table called «[table]», just do this

Similar Posts

• Postgresql index naming convention
• Postgresql-аналоги myslq-евской «ON DUPLICATE KEY UPDATE»
• PostgreSQL EXPLAIN
• SQL: выборка разреженных данных (не больше раза в час)
• docker-compose example for ceph, kafka, postgres cluster