Okay, so we have one table that appears to be having a problem in
replication. The unique thing about this table is that we have a field
that often times is null, yet it has in index as follows:
"tract_order_num_key" unique, btree (order_num)
So, this application has been running along just fine like this for a
couple of years. Is it possible that the above index is causing the
problem?
The difference between the data in this table on the primary and slave
does appear to be related to rows where the order_num field is null.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
