Re: [GENERAL] Strange duplicate key violation error

2007-06-28 Thread Richard Huxton
Casey Duncan wrote: There are in fact one of these tables for each schema, each one contains exactly one row (the "log" in the name is a bit misleading, these just contain the current replica state, not a running log). 2007-06-28 08:53:54.937 PDT [d:radio_reports_new u:slony s:4683d86f.3681 3

[GENERAL] Strange duplicate key violation error

2007-06-28 Thread Casey Duncan
I have this table "replica_sync_log" which is updated thousands of times a day to reflect the state of various schemas in a database which acts as an offline secondary to various other databases (each of the source databases is mapped to its own schema in the secondary). The table has the f