Re: Duplicate key error

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>, pgsql-general(at)postgresql(dot)org
Subject: Re: Duplicate key error
Date: 2021-03-03 16:16:06
Message-ID: c22a9fa0-9f3a-8b68-c1d4-a430cf7286bc@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/3/21 8:08 AM, Andrus wrote:
> 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).

And if that name already exists there would be a duplicate key error.

>
> Last inserted row data should remain.

I'm not understanding the above.

>
> Andrus.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tobias Lott 2021-03-03 16:26:56 Re: permission denied for pg_temp_XX when vacuuming
Previous Message Tom Lane 2021-03-03 16:10:28 Re: permission denied for pg_temp_XX when vacuuming