Re: Index scan does not return all the data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux