Postgres Pro
Downloads
Home   >   mailing lists

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

From Mani Sankar
Subject Re: Problem with constraint unique.
Date
Msg-id CAEtVwW0BnQVvNrnH0hckfNk8rTB-Q+dD1RVxXrtnZpMxxEAirg@mail.gmail.com
Whole thread Raw
In response to Re: Problem with constraint unique.  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-bugs
Tree view
Yeah correct got confused with PK and FK

Thanks, for correcting 

Regards,
Mani.

On Fri, 13 Dec, 2024, 12:05 am Greg Sabino Mullane, <htamfids@gmail.com> wrote:
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: Greg Sabino Mullane
Date:
Subject: Re: Problem with constraint unique.
Next
From: Nathan Bossart
Date:
Subject: Re: BUG #18711: Attempting a connection with a database name longer than 63 characters now fails