On 11/14/05, Tom Lane <[EMAIL PROTECTED]> wrote: > Merlin Moncure <[EMAIL PROTECTED]> writes: > > I just confirmed that there are duplicate p-keys in the source table :(. > > Well, that's not very good either, but at least it narrows down the > problem. > > Do the "duplicate" rows appear to be independent insertions, or > successive states of the same logical row? Looking at their xmin/xmax > might help determine this, and if the table has OIDs then looking at the > oid would be pretty conclusive.
no oid. esp=# select xmin, xmax, lastmod from parts_order_line_file where prl_combined_key = esp-# ' 00136860' and prl_seq_no in (20, 23); xmin | xmax | lastmod -----------+------+------------------------- 584527952 | 0 | 2005-09-15 11:17:17.062 584527961 | 0 | 2005-09-15 11:17:17.187 (2 rows) the nature of the file, unfortunately is that a record may be rewritten several times over it's lifespan, due to ISAM style resequencing on the table. the file is taken directly from user entry app so high speec race condition type behavior is unlikely, save for a order duplication aspect I need to check into. Being a ported COBOL app, tranasactions are one-record wonders, save for places where parts have been rewritten in pl/pgsql (does not apply here). Merlin ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster