Re: Problem with constraint unique.

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Mani Sankar <manisankar01695(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Марат Гасанян <marat_gasanyan(at)mail(dot)ru>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Problem with constraint unique.
Date: 2024-12-12 18:34:49
Message-ID: CAKAnmm+1+Q0P+P4t5tBGhk8=rNUDrskp4z-2QCyhAPeYRrHiDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Dec 12, 2024 at 12:52 PM Mani Sankar <manisankar01695(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mani Sankar 2024-12-12 18:44:22 Re: Problem with constraint unique.
Previous Message Mani Sankar 2024-12-12 17:52:02 Re: Problem with constraint unique.