Re: BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key - Mailing list pgsql-bugs

From Stephen Cuppett
Subject Re: BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key
Date
Msg-id F62CC1C9DC2ABC4A8D986537A79D324F0AA4AB2F6F@MERCMBX14.na.sas.com
Whole thread Raw
In response to Re: BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tm0sICBJIHRoaW5rIEkgc2VlIHdoYXQgaXMgaGFwcGVuaW5nLg0KDQpJIHN0
YXJ0ZWQgdHJhY2luZyB0aGUgdHJhbnNhY3Rpb24gYW5kIHNlZSB0aGF0IGFu
b3RoZXIgaGlnaCBsZXZlbCBvYmplY3QsIHdoZW4gZGVsZXRlZCwgZG9lcyBh
biBPTiBERUxFVEUgU0VUIE5VTEwsIHRoZW4gdGhlIGl0ZW0gdXBkYXRlZCBp
cyBkZWxldGVkLiAgU28gdGhlIEFGVEVSIFVQREFURSBpcyBydW4gZm9yIHRo
ZSByb3cuLiBldmVuIHRob3VnaCBpdCdzIGEgZGVsZXRlZCByb3cgbGF0ZXIg
aW4gdGhlIHNlcXVlbmNlLi4uDQoNCg0KU28gaXQgbG9va3MgbGlrZSB0aGlz
DQoNCkEgLT4gQiA8LS18DQpBIC0+IEQgLT4gRQ0KDQpXaGVyZToNCg0KICAg
ICAgICBCIHJlZmVyZW5jZXMgQSBPTiBERUxFVEUgQ0FTQ0FERQ0KICAgICAg
RCByZWZlcmVuY2VzIEEgT04gREVMRVRFIENBU0NBREUNCiAgICAgIEUgcmVm
ZXJlbmNlcyBEIE9OIERFTEVURSBDQVNDQURFDQogICAgICBFIHJlZmVyZW5j
ZXMgQiBPTiBERUxFVEUgU0VUIE5VTEwNCg0KV2hlbiBBIGlzIGRlbGV0ZWQs
IEIgaXMgZGVsZXRlZCwgRSBpcyBzZXQgbnVsbC4gIFRoZW4sIEQgaXMgZGVs
ZXRlZCBhbmQgRSBpcyBkZWxldGVkLg0KDQpGT1IgRVZFUlkgUk9XIEFGVEVS
IFVQREFURSBpcyBydW4gb24gRSBmb3Igcm93cyB0aGF0IG5vIGxvbmdlciBl
eGlzdC4NCg0KTm90IHN1cmUgaWYgdGhhdCdzIGEgYnVnIG9yIG5vdC4uLiBu
b3Qgc3VyZSBpdCB3b3VsZCBiZSB1bmRlc2lyYWJsZSB1bmRlciBjb25kaXRp
b25zIGZvciB0aGF0IG5vdCB0byBydW4gZm9yIHRob3NlIHR1cGxlcyB0aGF0
IGFyZSBhbHJlYWR5IGdvbmUuDQoNClN0ZXZlDQoNCi0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KU3RlcGhlbiBDdXBwZXR0
DQpTQVPCriBDZXJ0aWZpZWQgQWR2YW5jZWQgUHJvZ3JhbW1lciBmb3IgU0FT
OcKuDQpUZWw6ICsxIDkxOSA1MzEgMDY1OSDilqogU3RlcGhlbi5DdXBwZXR0
QHNhcy5jb20NCnd3dy5zYXMuY29tDQoNClNBU8KuIOKApiBUSEUgUE9XRVIg
VE8gS05PV8KuDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZy
b206IFRvbSBMYW5lIFttYWlsdG86dGdsQHNzcy5wZ2gucGEudXNdDQpTZW50
OiBXZWRuZXNkYXksIFNlcHRlbWJlciAwMywgMjAwOCAxMjoyNCBQTQ0KVG86
IFN0ZXBoZW4gQ3VwcGV0dA0KQ2M6IHBnc3FsLWJ1Z3NAcG9zdGdyZXNxbC5v
cmcNClN1YmplY3Q6IFJlOiBbQlVHU10gQlVHICM0Mzk2OiBUcmlnZ2VyIGV2
ZW50IGZpcmVkICJVUERBVEUiIHdoZW4gIkRFTEVURSIgaGFwcGVuaW5nIHZp
YSBmb3JlaWduIGtleQ0KDQpTdGVwaGVuIEN1cHBldHQgPFN0ZXBoZW4uQ3Vw
cGV0dEBzYXMuY29tPiB3cml0ZXM6DQo+IEkgY2FuIHVwbG9hZCB0aGUgd2hv
bGUgc2NoZW1hIHNvbWVwbGFjZSwgb3IgaXMgYXR0YWNoaW5nIGEgZmV3IGZp
bGVzIGhlcmUgb2theT8NCg0KV2hhdCB3b3VsZCBiZSBlYXNpZXN0IGZyb20g
dGhpcyBlbmQgaXMgYSBTUUwgc2NyaXB0IHRvIGNyZWF0ZSB0aGUNCnRhYmxl
cywgaW5zZXJ0IGFueSB0ZXN0IGRhdGEgbmVlZGVkLCBhbmQgdGhlbiByZXBy
b2R1Y2UgdGhlIHByb2JsZW0sDQpzdGFydGluZyBmcm9tIGFuIGVtcHR5IGRh
dGFiYXNlLiAgQSAicGdfZHVtcCAtcyIgc2NyaXB0IGlzIHVzdWFsbHkNCmEg
Z29vZCBzdGFydGluZyBwbGFjZSBmb3IgbWFraW5nIHRoYXQuDQoNCiAgICAg
ICAgICAgICAgICAgICAgICAgIHJlZ2FyZHMsIHRvbSBsYW5lDQoNCg==

pgsql-bugs by date:

Previous
From: Stephen Cuppett
Date:
Subject: Re: BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key
Next
From: Stephen Cuppett
Date:
Subject: Re: BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key