Re: 8.0 -> 8.1 dump duplicate key problem?

On 11/14/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Merlin Moncure <mmoncure@gmail.com> writes:
> > 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)
>
> I think you need to try this with enable_indexscan = 0; it should be

right, I missed that!

esp=# select prl_combined_key, prl_seq_no, xmin, xmax, lastmod from
parts_order_line_file where prl_combined_key = ' 00136860' and
prl_seq_no in (20, 23);prl_combined_key | prl_seq_no |   xmin    | xmax |         lastmod
------------------+------------+-----------+------+------------------------- 00136860        |         20 | 584527952 |
  0 | 2005-09-15 11:17:17.062 00136860        |         20 | 584412245 |    0 | 2005-09-15 09:31:35.381 00136860
|        23 | 584527961 |    0 | 2005-09-15 11:17:17.187 00136860        |         23 | 584415243 |    0 | 2005-09-15
09:32:18.898

merlin