From: | M Sarwar <sarwarmd02(at)outlook(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "wolters(dot)k(at)web(dot)de" <wolters(dot)k(at)web(dot)de>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints |
Date: | 2024-05-23 01:22:28 |
Message-ID: | DM4PR19MB59782A6C8D95146C6A608B15D3F42@DM4PR19MB5978.namprd19.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)g(dot)johnston(at)gmail(dot)com>
Sent: Wednesday, May 22, 2024 8:35 PM
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: wolters(dot)k(at)web(dot)de <wolters(dot)k(at)web(dot)de>; pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)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(at)outlook(dot)com<mailto:sarwarmd02(at)outlook(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Rui DeSousa | 2024-05-23 02:42:13 | Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints |
Previous Message | David G. Johnston | 2024-05-23 00:35:40 | Re: AFTER INSERT trigger INSERT into another table-B are ignoring Table-B constraints |