Re: strange index error - Mailing list pgsql-novice

From Tom Lane
Subject Re: strange index error
Date
Msg-id 21502.1013527272@sss.pgh.pa.us
Whole thread Raw
In response to strange index error  ("Duncan Adams (DNS)" <duncan.adams@vcontractor.co.za>)
List pgsql-novice
"Duncan Adams  (DNS)" <duncan.adams@vcontractor.co.za> writes:
> i have the following, (bellow)

You sure you didn't do a "setval" that changed the sequence counter back
to about 10?  It evidently had gotten as high as 129 at one point.

If there is anything funny here it's with the sequence, not the index.
We've heard a couple unrepeatable reports of sequences "losing count",
but I'm not entirely convinced that there's really a problem.

            regards, tom lane

pgsql-novice by date:

Previous
From: Pam Wampler
Date:
Subject: What table shows statistics of vacuum analyze
Next
From: Joe Block
Date:
Subject: Database size