IronPort-Data: A9a23:un+k7qzv/AE3p7/Zo8p6t+e7xirEfRIJ4+MujC+fZmUNrF6WrkVRn
 DRLCzzXPv/cZTf3LYp+aY6x9EoE6sSAndM3SABl+S00HyNBpPSeCIXCJC8cHc8zwu4v7q5Dx
 59DAjUVBJlsFhcwnj/0bv656yMUOZigHtIQMsadUsxKbVIiGX9JZS5LwbZj2NY02ILhWmthh
 PupyyHhEA79s9JLGj9Mg06zgEsHUCPa4W5wUvQWPJinjXeG/5UnJMt3yZKZdhMUdrJp8tuSH
 I4v+l0bElTxpH/BAvv9+lryn9ZjrrT6ZWBigVIOM0Sub4QrSoXfHc/XOdJFAXq7hQllkPh2x
 8h1rJOAeD0YI6nLsuhMbgNKHBlHaPguFL/veRBTsOS15mifKT7J/K8rC0s7e4oF5uxwHGdCs
 +QCLywAZQyCgOTwx6+nTu5rhYIoK8yD0IE34yk8i22GS6h4B8yZK0nJzYYwMDMYpM1HG7P7b
 tASLwRobRDEbgRSO1E/DZU5kPazwHL4dlW0rXrL+fFuvDSPk2Sd1pDdd+uKfefRb/4PuUOZp
 TnfpCPQADcVYYn3JT2tqSv33bCncTnAcJodD6S8s+VzhHWXx3cPE1sOUkCnruO0kVe6HdVFJ
 CQpFjEGqKEz8AmuUYP7Vhjh+nqc5EZAAZxXDvEw7xyLxuzM+QGFC2MYTzlHLts7qMsxQj9s3
 ViM9z/0OdBxmLqaVEqE+YellwKvPS8/IT4/fz0LdTJQtrEPv7oPph7IS99iFou8gdv0BSz8z
 li2QM4W1+p7YSkjh/rTwLzXv96/jsSWEFZuum07Skrgt1kjP9L8O+RE/HCCta4YRLt1WGVtq
 5TtdyRzHIkz4XylkSWMRKAIA+uv7vPcajnE2wYzRd8m6iin/GOlccZI+jZiKUx1M8ECPzj0f
 EvUvgAX75hWVJdLUUOVS93vYyjJ5fG/fTgAahwyRocUCnSWXFLclByCnWbKgwjQfLEEyMnTw
 6uzf8e2Fmo9Aq961jewTOp1+eZ1mnFhnTKOHM2llkjPPV+iiJi9Gedt3LymPrBR0U94iF6Fm
 zqiH5fXl08PDL2mCsUp2ddMdA9bcBDX+qwaW+QML7XYfWKK6UkkCvTLxqgmdZAtlKNPjuDS9
 228XUkw9bYMrSyvFOl+UVg6MOmHdc8n/RoTZHVwVX71hSRLSdvxvc83KspvFZF6pbcL5aMlH
 5EtJZ/catwREW6v02pGMvHAQHlKL0nDafSmZHb+P1DSvvdIG2T0xzMTVle3r3lRU3Dv7KPTY
 dSIj2vmfHbKfCw6ZO6+VR5l5wrZUaQ18A6qY3b1Hw==
IronPort-HdrOrdr: A9a23:KjmE26HaplZ9M+u5pLqFZJHXdLJyesId70hD6qkvc3Fom52j/f
 xGws5x6fatskd3ZJhSo6HnBEDgewKryXcb2/h1AV7PZmfbUQiTXchfBOnZslnd8kTFn4Ywup
 uIGJIfNDSENykZsS+M2njaLz9P+ri62ZHtod2b42ZmTAlsZa0lxRx+EBynHkp/QxQDLYYlFb
 KHj/A37AaISDAyVICWF3MFV+/Mq5ngj5T9eyMLABYh9U2nkS6o0rjnCBKVty1uGQ+ngI1SvF
 QtoTaJqZlLgMvLhCM0EFWjrqi+reGRhuerwvb8yvT9ZA+cyTpAL74RIoFq9ApF2N1Hrmxa2O
 Uk6i1QRPhb+jffeHq4rgDq3BSl2DEy62X6wVvdmnf7p9flLQhKfvapqLgpAScx0XBQzu2UEZ
 g7oF6xpt5SF1fNjS7979/HW1VjkVe1u2MrlaoWg2ZEWYUTZbdNpchHlXklZ6soDWb/8sQqAe
 NuBMbT6LJfdk6bdWnQui1qzMa3Vno+Ex+aSgwJu9CT0TJRgHdlpnFosPA3jzMF7tYwWpNE7+
 PLPuBhk6xPVNYfaeZnCOIIUaKMexzwqNL3QROvyHjcZdw60ij22uTKCZ0OlZ2XUY1Nyocuk5
 LcV14dvXIueivVeLOz4KE=
From: "Voillequin, Jean-Marc" <Jean-Marc.Voillequin@moodys.com>
To: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Subject: enable/disable instead of trigger
Thread-Topic: enable/disable instead of trigger
Thread-Index: AdhObsjF3BQmL/UvSTqiogSbyurYMQ==
Date: Tue, 12 Apr 2022 13:12:25 +0000
Message-ID: 
 <MN2PR20MB27354FD69C96A044D236301BBEED9@MN2PR20MB2735.namprd20.prod.outlook.com>
Accept-Language: fr-FR, en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?1vdVV9m10aWsiHqvhH1XZozZB9XCBWdPWWK4XJQKKSQ+chaFHfDUYJo/dlBL?=
 =?us-ascii?Q?UvDNk4JHSSDLiTCxDAesF1NKwx69oJTmgVNG7YneNuBJ+Kpp6irGfQxcfisC?=
 =?us-ascii?Q?ELeEeMh+ot4CMwmbB7n6cDVdG28VAG6pUo5M95jNKiEH8SlO9O3tu1o6RvQW?=
 =?us-ascii?Q?81U8x3pT0/IB0nKes8tnKMovm6Mxjnhji4to72gv/0vqnjP7VCAP3AtHf4uQ?=
 =?us-ascii?Q?nZ+osslwkF8Ndu5AcD/9HJ1Ew5vV5IkLjlgwNLaFUMcas0EHC73FtuFY+llD?=
 =?us-ascii?Q?utYonvqQ2IoThcZRlz88P6pCDRV2OokOxwe/1ueGcbGMjFpB5qAJjo73kmUu?=
 =?us-ascii?Q?6kcQS2G2+wQVJhV39qIfmXXr5FlCEalPaRjVIRs+tKMZu4tyOPhdsOGdAmuZ?=
 =?us-ascii?Q?3jiTAxqjHBdrEIcMtvU5qmXKz4DcPrm9XuVeHZlJ3FyRUA7nwqaJgAwL9MAj?=
 =?us-ascii?Q?fEuPNUlJIh/zpo7bQWLJ4feEkFn4RFyEsaHLAOqNRy+ajYfAB9cR9bisZyL4?=
 =?us-ascii?Q?qOdJFOSL0A8zRGv3GeehmYAI7yI+wsnFSH2YsHvdLfF2n8RF3WrHDZeh94ul?=
 =?us-ascii?Q?iLlKPQGW9SNPlF3J2gl7+RulI5Gd+VxJEs3Djp7j23h9V9i25j3aX4tojmYH?=
 =?us-ascii?Q?Hy5oLm7DiULt1IiCz7cJnLVTzi/yIPMvmFIZq9yOyc3JV93auaZkhRMamORi?=
 =?us-ascii?Q?OMgh7v54Zz3MmRmU0bNK28Vhjo0ubiBlcyuqOdT1Hxo0nIqFKzH+DqGkDqCh?=
 =?us-ascii?Q?Sm6XNYslDyUdPx4fRgNTcGTuVbB9UUY4LksOCj1JUAAbUih3w2U3n2D+o5l7?=
 =?us-ascii?Q?e1V1r/aGL7847gSmQZIt51gv1INL7gu1k9paRTjye17SL+ZU6QpFYpfaIVq3?=
 =?us-ascii?Q?JbGT1fUg2m90wC+cZf1Aj5nJbAnsKRRZXDEhMR2hnlBO8YSuFTX5Bpf71rEo?=
 =?us-ascii?Q?Y/VgWTHCMbyXiGtgqgYoEPcRlbCU5TqJYzdl8byfDVanqjrGBkJ3z5QYP0mO?=
 =?us-ascii?Q?PbQH2heK3dWVgy3Kn6dQ/w08PcHEA/zXvUWfL33kCOpd21bWxsUPsPBnj07O?=
 =?us-ascii?Q?RUeBgC1++X6erlzd729LWDySbmRCc1Xax05YGFMzJw4uo6zYI6K02dS8dZoG?=
 =?us-ascii?Q?D1jQ5bv/mhYlvdof75Dse2tHCYfZGcNnCoEQ1OaquQvCIs0LllGaeW5xxIac?=
 =?us-ascii?Q?bhKWJcOgr0j8Q/2jJ3NnW64q12YR1SZ5oyq/2UHl3CShEXbfRAJFACksGvwr?=
 =?us-ascii?Q?kW7e+X388h1GC+P5vOUyptSl08AAMC8c3Oj5oK2Tz0vPSGe69V/VxttXKg4V?=
 =?us-ascii?Q?KjXBPEwF780NtwOCGXgcdmj6SVA7JQvxBGsR9OAjl+uGLsBwFZyqhWlTgPXG?=
 =?us-ascii?Q?awrt4OqYhmOzVcht4bKZE0EoplyS5SZVlnPydrWXsjHVizeriEVvsU57+iIZ?=
 =?us-ascii?Q?AmwI7Np9tLMKjllFSQClzbLWZ/8Au2EdNSIi4n44oXN9irDqBg2aMRd6uZu1?=
 =?us-ascii?Q?KpdZ8ghfAzPVz2E2Ca+c8io+nw68XMGmqPJoMWH1ntr7tiSC52bCFNK94yYu?=
 =?us-ascii?Q?XU2AJQjPdiMU7XwVfP6CKGX3/1BYB6djIhkOnRcbqNUMuOJKrqNRaJXSzAOD?=
 =?us-ascii?Q?CjZe0yWi0uU/r36tYXNxiv7H8AnhYp1UbnGxgt3s5naejClKfMOmDdWY5SYv?=
 =?us-ascii?Q?zFCJr5tnZXDU81XsP/txlsXhZVRab6sVPPrEeHwnFm3WAiRNFPTKxDr47cv5?=
 =?us-ascii?Q?F/9N+M0B/A=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_MN2PR20MB27354FD69C96A044D236301BBEED9MN2PR20MB2735namp_"
MIME-Version: 1.0
X-OriginatorOrg: moodys.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: MN2PR20MB2735.namprd20.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 887bca82-9fbb-444b-a1c3-08da1c8616a2
X-MS-Exchange-CrossTenant-originalarrivaltime: 12 Apr 2022 13:12:25.6361
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 1061a8b8-b1ee-4249-bb84-9a2cd2792fae
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 EO3oekYyqCSnoK2malp5hHMgsz+PIRv7AU4IwvR0L/eYnuziwE770X5qNB0RsAznXVqq0l1DXtCBEy1bj2Gfkw==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DS7PR20MB4622
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/MN2PR20MB27354FD69C96A044D236301BBEED9%40MN2PR20MB2735.namprd20.prod.outlook.com>
Precedence: bulk

--_000_MN2PR20MB27354FD69C96A044D236301BBEED9MN2PR20MB2735namp_
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

Hello guys,
Is there a syntax to enable/disable an instead of trigger?
For a table, it's ok, but for a view, the alter view ... enable/disable tri=
gger ... does not exist.
Regards.

-----------------------------------------

Moody's monitors email communications through its networks for regulatory c=
ompliance purposes and to protect its customers, employees and business and=
 where allowed to do so by applicable law. The information contained in thi=
s e-mail message, and any attachment thereto, is confidential and may not b=
e disclosed without our express permission. If you are not the intended rec=
ipient or an employee or agent responsible for delivering this message to t=
he intended recipient, you are hereby notified that you have received this =
message in error and that any review, dissemination, distribution or copyin=
g of this message, or any attachment thereto, in whole or in part, is stric=
tly prohibited. If you have received this message in error, please immediat=
ely notify us by telephone, fax or e-mail and delete the message and all of=
 its attachments. Every effort is made to keep our network free from viruse=
s. You should, however, review this e-mail message, as well as any attachme=
nt thereto, for viruses. We take no responsibility and have no liability fo=
r any computer virus which may be transferred via this e-mail message.

-----------------------------------------

--_000_MN2PR20MB27354FD69C96A044D236301BBEED9MN2PR20MB2735namp_
Content-Type: text/html; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:DengXian;
	panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:"\@DengXian";
	panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span lang=3D"FR">Hello guys,<o:p></o:p></span></p>
<p class=3D"MsoNormal">Is there a syntax to enable/disable an instead of tr=
igger?<o:p></o:p></p>
<p class=3D"MsoNormal">For a table, it&#8217;s ok, but for a view, the alte=
r view &#8230; enable/disable trigger &#8230; does not exist.<o:p></o:p></p>
<p class=3D"MsoNormal">Regards.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div><div>-----------------------------------------<div>Moody's monitors em=
ail communications through its networks for regulatory compliance purposes =
and to protect its customers, employees and business and where allowed to d=
o so by applicable law. The information contained in this e-mail message, a=
nd any attachment thereto, is confidential and may not be disclosed without=
 our express permission. If you are not the intended recipient or an employ=
ee or agent responsible for delivering this message to the intended recipie=
nt, you are hereby notified that you have received this message in error an=
d that any review, dissemination, distribution or copying of this message, =
or any attachment thereto, in whole or in part, is strictly prohibited. If =
you have received this message in error, please immediately notify us by te=
lephone, fax or e-mail and delete the message and all of its attachments. E=
very effort is made to keep our network free from viruses. You should, howe=
ver, review this e-mail message, as well as any attachment thereto, for vir=
uses. We take no responsibility and have no liability for any computer viru=
s which may be transferred via this e-mail message. <br></div><div>--------=
---------------------------------</div></div></div></body>
</html>

--_000_MN2PR20MB27354FD69C96A044D236301BBEED9MN2PR20MB2735namp_--