Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14940: Duplicated records inspite of primary key and uniqueconstraint - Mailing list pgsql-bugs

From Tomas Vondra
Subject Re: BUG #14940: Duplicated records inspite of primary key and uniqueconstraint
Date
Msg-id d3dbeb59-67ac-9044-54d0-6df9259fb899@2ndquadrant.com
Whole thread Raw
In response to Re: BUG #14940: Duplicated records inspite of primary key and uniqueconstraint  (Сергей А. Фролов<sergey.frolov@smetarik.ru>)
List pgsql-bugs
Tree view 

On 12/04/2017 05:06 PM, Сергей А. Фролов wrote:
> I have scanned all pages for tran numbers 370881,370882,364507 .
> 
> It looks like 364507 is the number of restore transaction.
> 
> Is it possible that  370881,370882 are the numbers of failed maintenance
> jobs like vacuum or rindex?
> 

I don't think any of those operations create new rows in the heap.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: Сергей А. Фролов
Date:
Subject: Re: BUG #14940: Duplicated records inspite of primary key and uniqueconstraint
Next
From: dap@joyent.com
Date:
Subject: BUG #14945: postmaster deadlock while logging after syslogger exited