Re: duplicate key violates unique constraint pg_toast_635216540

warehouse=# select count(distinct chunk_id) from
pg_toast.pg_toast_635216540;
count
-------
74557
(1 row)

We're on version 8.0.7

On 10/16/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "Paul Laughlin" <plaughlin@gmail.com> writes:
> > For the last 6 months or so we've had an intermittent issue while doing
> a
> > data import with a simple update statement.  The fix that we've found
> for
> > this issue is to REINDEX TABLE <tablename>;
>
> What PG version is this?
>
> Are you sure that the REINDEX actually does anything, as opposed to
> merely retrying the data import?  I'm thinking you may be having
> problems with OID collisions after OID wraparound, which is something
> 8.1 should defend against but no earlier version does.
>
> What do you get from
>         select count(distinct chunk_id) from pg_toast.pg_toast_635216540 ;
>
>                         regards, tom lane
>