Postgres Pro
Downloads
Home   >   mailing lists

Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints - Mailing list pgsql-admin

From M Sarwar
Subject Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints
Date
Msg-id DM4PR19MB59782A6C8D95146C6A608B15D3F42@DM4PR19MB5978.namprd19.prod.outlook.com
Whole thread Raw
In response to Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints
List pgsql-admin
Tree view
Hi David,
I did verify at Ver 13 and this ( UNIQUE NULLS NOT DISTINCT ) syntax is not existing there. That means, I need to work on it without this option.
My team will not upgrade from 13 due to number of reasons.
Thank you,
Sarwar

From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Wednesday, May 22, 2024 8:35 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: wolters.k@web.de <wolters.k@web.de>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints
 
On Wed, May 22, 2024, 18:29 M Sarwar <sarwarmd02@outlook.com> wrote:


My Postgress version is 13.5. I hope that it is not due to the version.

Check the current docs, confirm the syntax is documented there, then look at the v13 docs and see whether it is present or not.

David J.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints
Next
From: Rui DeSousa
Date:
Subject: Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints