On 11/14/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Merlin Moncure <mmoncure@gmail.com> 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.062584527961 | 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