Subject: Re: Duplicate key error
To: Andrus <kobruleht2@hot.ee>, pgsql-general@postgresql.org
References: <a8656d4f-d692-ffae-077e-304f348e25bf@hot.ee>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <5b68b4b3-b957-5009-cf3e-4bbc9dcbd0d9@aklaver.com>
Date: Wed, 3 Mar 2021 07:42:20 -0800
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.8.0
MIME-Version: 1.0
In-Reply-To: <a8656d4f-d692-ffae-077e-304f348e25bf@hot.ee>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/5b68b4b3-b957-5009-cf3e-4bbc9dcbd0d9%40aklaver.com>
Precedence: bulk

On 3/3/21 7:23 AM, Andrus wrote:
> Hi!
> 
> Sometimes duplicate key error
> 
>      duplicate key value violates unique constraint "session_pkey"
>      Key (workplace)=(WIN-N9BSKUNKBC8 ) already exists.
> 
> occurs in script:
> 
>      delete from session where workplace='WIN-N9BSKUNKBC8' ;
>      INSERT INTO session (workplace,ipaddress,logintime,loggeduser)
>      SELECT 'WIN-N9BSKUNKBC8' , 
> inet_client_addr()::CHAR(14),current_timestamp::CHAR(28),CURRENT_USER 
> WHERE NOT EXISTS (SELECT 1 FROM session WHERE workplace='WIN-N9BSKUNKBC8' )
> 
> Sript is running form windows task scheduler on every 10 minutes. Error 
> occurs only sometimes.

There is no other process inserting  to this table?


-- 
Adrian Klaver
adrian.klaver@aklaver.com