Re: Duplicate key error

From: Andrus <kobruleht2(at)hot(dot)ee>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Duplicate key error
Date: 2021-03-04 17:17:16
Message-ID: 8bd1ce20-a369-7adf-2bb5-20fb6742c232@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

> Since we have not actually seen the entire script nor have any idea
> what the other process is, there is no way to answer this.

This is the same whole script. It will ran by multiple scheduled tasks,
maybe at same time.

It registers logged in user. Different processes may have same user
name. In this case one row should remain.

I can just ignore duplicate key error on commit but maybe there is some
better way not to cause error.

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-03-04 18:07:31 Re: Schema in trigger in logical replication
Previous Message Adrian Klaver 2021-03-04 16:58:30 Re: Schema in trigger in logical replication