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.
