Re: Problem with constraint unique. - Mailing list pgsql-bugs

From Greg Sabino Mullane
Subject Re: Problem with constraint unique.
Date
Msg-id CAKAnmm+1+Q0P+P4t5tBGhk8=rNUDrskp4z-2QCyhAPeYRrHiDA@mail.gmail.com
Whole thread Raw
In response to Re: Problem with constraint unique.  (Mani Sankar <manisankar01695@gmail.com>)
Responses Re: Problem with constraint unique.
List pgsql-bugs
On Thu, Dec 12, 2024 at 12:52 PM Mani Sankar <manisankar01695@gmail.com> wrote:
One possible reason I can think of is setting the session_replication_role to replica do some insert that violates the constraints and then set it back to orgin.

session_replication_role can disable triggers and rules, but primary keys will still be enforced.

Cheers,
Greg
 

pgsql-bugs by date:

Previous
From: Mani Sankar
Date:
Subject: Re: Problem with constraint unique.
Next
From: Mani Sankar
Date:
Subject: Re: Problem with constraint unique.