Comment 2 for bug 1458831

Revision history for this message
Peter Gervai (grin) wrote :

Indeed somehow psql was able to squeeze two equal id into a primary key. I found no visible reason for this treason, VACUUM was perfectly happy, but REINDEX complained. I see that the sequence was at a wrong counter but still it must not happen no matter whether it's coming from DEFAULT.
Anyway, manually incremented the entry and it should work now.
Closing as invalid, this was no NAV fault (or even if it was it must not be allowed by psql).