[GENERAL] ON CONFLICT DO for UPDATE statements

2016-05-12 Thread Klaus P. Pieper - ibeq GmbH
We run two separate databases which are synchronized through our own replication system (two master databases, so we use our own trigger based methods). Let's call the two databases "main" and "remote". >From time to time we get constraint violations on sorting fields classified >UNIQUE when us

[GENERAL] ON CONFLICT DO for UPDATE statements

2016-05-12 Thread Klaus P. Pieper
We run two separate databases which are synchronized through our own replication system (two master databases, so we use our own trigger based methods). Let's call the two databases "main" and "remote". >From time to time we get constraint violations on sorting fields classified UNIQUE when user