Index scan does not return all the data

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Index scan does not return all the data

S. Bob
Hi all;


we have a client that has run into an issue, they have a PK on an id
column and another unique index on the id and a timestamp. when we run a
select it selects one of several indexes, in some cases a non unique
index on a secondary ID, however when we do a pg_dump, or a CREATE TABLE
x AS select * from this table then we get many many duplicates that
violate the PK and the unique index.

Thoughts?


Thanks in advance


Reply | Threaded
Open this post in threaded view
|

Re: Index scan does not return all the data

Ron-2
On 1/26/19 9:33 AM, S. Bob wrote:

> Hi all;
>
>
> we have a client that has run into an issue, they have a PK on an id
> column and another unique index on the id and a timestamp. when we run a
> select it selects one of several indexes, in some cases a non unique index
> on a secondary ID, however when we do a pg_dump, or a CREATE TABLE x AS
> select * from this table then we get many many duplicates that violate the
> PK and the unique index.
>
> Thoughts?

Sounds like a corrupt index.  "REINDEX TABLE foo" and -- if not already --
update to the latest release of your version.



--
Angular momentum makes the world go 'round.