pg_authid has duplicated rows

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

 



Hi,
Today I faced a situation where I saw a postgresql 9.2 database that had duplicated rows in pg_autid. I saw 6 roles while 3 of them were duplicated (3 uniques rolenames in total). I checked and the oid of the duplicates were the same oid as the originals. The solution was running vacuum on the table but I wanted to understand how this situation was created ? Why even with unique index on the rolname I saw duplicated values for rolname ?

Thanks , Mariel.

[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