pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrus <kobruleht2@hot.ee>
To: Adrian Klaver <adrian.klaver@aklaver.com>
To: pgsql-general@postgresql.org
Subject: Re: Duplicate key error
Date: Wed, 3 Mar 2021 18:08:17 +0200
Message-ID: <97577cda-b3fa-4edb-1c8a-2b39afad65c6@hot.ee> (raw)
In-Reply-To: <5b68b4b3-b957-5009-cf3e-4bbc9dcbd0d9@aklaver.com>
References: <a8656d4f-d692-ffae-077e-304f348e25bf@hot.ee>
	<5b68b4b3-b957-5009-cf3e-4bbc9dcbd0d9@aklaver.com>

Hi!

> There is no other process inserting  to this table?
>
There may be other processes in this server trying to insert same 
primary key value (server name).

Last inserted row data should remain.

Andrus.

view thread (22+ messages)  latest in thread

Message-ID: <97577cda-b3fa-4edb-1c8a-2b39afad65c6@hot.ee>
Permalink:  ../97577cda-b3fa-4edb-1c8a-2b39afad65c6@hot.ee/
Also on:    postgresql.org/message-id/97577cda-b3fa-4edb-1c8a-2b39afad65c6@hot.ee

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: kobruleht2@hot.ee, adrian.klaver@aklaver.com
  Subject: Re: Duplicate key error
  In-Reply-To: <97577cda-b3fa-4edb-1c8a-2b39afad65c6@hot.ee>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox