Thanks a lot Tomas for the reply.
Which version are you running, exactly? Whih minor version?
[Pawan]: Its (PostgreSQL) 9.5.9
sai=> select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 9.5.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623
(Red Hat 4.8.5-11), 64-bit
(1 row)
Why do you think it's the issue you linked?
[Pawan]: Because the thread which I shared also has problem statement like
"Duplicate entries of Primary key" .
If this is also known to this version, I will be appreciating a lot if we have
some Workaround or config change.
In our production: See below entries, proc_id is primary key and we can see
duplicate entries. How it is possible?
sai=> select ctid,proc_id from etl_status where proc_id='2993229';
ctid | proc_id
----------+---------
(381,20) | 2993229
(388,28) | 2993229
(2 rows)
Any idea, how it happened?
I will waiting for your reply
WBR,
-Pawan
-----Original Message-----
From: Tomas Vondra <[email protected]>
Sent: Thursday, July 04, 2019 10:18 PM
To: Kumar, Pawan (Nokia - IN/Bangalore) <[email protected]>
Cc: [email protected]; [email protected]; [email protected];
[email protected]
Subject: Re: duplicate key entries for primary key -- need urgent help
On Thu, Jul 04, 2019 at 01:37:01PM +0000, Kumar, Pawan (Nokia - IN/Bangalore)
wrote:
>Hi Guys,
>
>Can you please help here?
>
>Below reported issue in past about duplicate key entries for primary key.
>https://www.postgresql.org/message-id/[email protected]
>
>the solution was provided in 9.3 version of postgres but it seems issue is
>still there in 9.5 version which I am running currently.
>
>Can you please let me know if this is also known in 9.5? any fix or Workaround
>please?
>
Which version are you running, exactly? Whih minor version?
Why do you think it's the issue you linked?
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
