Re: [HACKERS] Duplicated Keys in PITR

2009-08-20 Thread Ygor Degani
> How are your duplicate keys being generated? Is there a unique index on them? They are generated during recover. Yes, there is a unique index. > Are the keys there if you use a sequential scan or only if you use an > index to look them up? I used a sequential scan. >Have you been running 8.3.5

Re: [HACKERS] Duplicated Keys in PITR

2009-08-20 Thread Greg Stark
On Thu, Aug 20, 2009 at 4:13 PM, Ygor Degani wrote: > When recover a database using a continuous archive backup, i detected some > duplicated keys. This there isn't in the production database. > I use postgres-8.3.5. > anyone know why this happens? Uhm, well it's not supposed to. Do you have more

[HACKERS] Duplicated Keys in PITR

2009-08-20 Thread Ygor Degani
When recover a database using a continuous archive backup, i detected some duplicated keys. This there isn't in the production database. I use postgres-8.3.5. anyone know why this happens? Regards, -- Ygor Degani

[HACKERS] Duplicated Keys in PITR

2009-08-20 Thread Ygor Degani
When recover a database using a continuous archive backup, i detected some duplicated keys. This there isn't in the production database. I use postgres-8.3.5. anyone know why this happens? Regards, -- Ygor Degani