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 F62CC1C9DC2ABC4A8D986537A79D324F0AA4AB31C2@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
WWVzLiAgSW4gbXkgY2FzZSBJIHdhbnQgdGhlIGhpc3RvcnkgZ29uZSB0b28u
ICBLZWVwaW5nIHRoZSBoaXN0b3J5IHdvdWxkbid0IGh1cnQsIGJ1dCBpdCdz
IGp1c3QgYSBwcmVmZXJlbmNlLg0KDQpJZiBJIGRpZCBrZWVwIHRoZSBoaXN0
b3J5IEkgZGVmaW5pdGVseSBkb24ndCB3YW50IHRoYXQgbGFzdCBVUERBVEUg
d2hlcmUgRSBpcyBzZXQgbnVsbC4uLiBidXQgdGhhdCdzIGVhc2lseSBjaXJj
dW12ZW50ZWQgdmlhIHRoZSB0cmlnZ2VyLg0KDQpUaGFua3MgZm9yIHRoZSBw
b2ludGVyIHRvIGxvb2sgZm9yIHRoZSBvdGhlciBwYXRoIQ0KDQpUaGFua3Ms
DQoNClN0ZXZlDQoNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLQ0KU3RlcGhlbiBDdXBwZXR0DQpTQVPCriBDZXJ0aWZpZWQg
QWR2YW5jZWQgUHJvZ3JhbW1lciBmb3IgU0FTOcKuDQpUZWw6ICsxIDkxOSA1
MzEgMDY1OSDilqogU3RlcGhlbi5DdXBwZXR0QHNhcy5jb20NCnd3dy5zYXMu
Y29tDQoNClNBU8KuIOKApiBUSEUgUE9XRVIgVE8gS05PV8KuDQoNCg0KLS0t
LS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IFRvbSBMYW5lIFttYWls
dG86dGdsQHNzcy5wZ2gucGEudXNdDQpTZW50OiBXZWRuZXNkYXksIFNlcHRl
bWJlciAwMywgMjAwOCAxOjA5IFBNDQpUbzogU3RlcGhlbiBDdXBwZXR0DQpD
YzogcGdzcWwtYnVnc0Bwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogUmU6IFtC
VUdTXSBCVUcgIzQzOTY6IFRyaWdnZXIgZXZlbnQgZmlyZWQgIlVQREFURSIg
d2hlbiAiREVMRVRFIiBoYXBwZW5pbmcgdmlhIGZvcmVpZ24ga2V5DQoNClN0
ZXBoZW4gQ3VwcGV0dCA8U3RlcGhlbi5DdXBwZXR0QHNhcy5jb20+IHdyaXRl
czoNCj4gV2hlbiBBIGlzIGRlbGV0ZWQsIEIgaXMgZGVsZXRlZCwgRSBpcyBz
ZXQgbnVsbC4gIFRoZW4sIEQgaXMgZGVsZXRlZCBhbmQgRSBpcyBkZWxldGVk
Lg0KDQo+IEZPUiBFVkVSWSBST1cgQUZURVIgVVBEQVRFIGlzIHJ1biBvbiBF
IGZvciByb3dzIHRoYXQgbm8gbG9uZ2VyIGV4aXN0Lg0KDQo+IE5vdCBzdXJl
IGlmIHRoYXQncyBhIGJ1ZyBvciBub3QuLi4gbm90IHN1cmUgaXQgd291bGQg
YmUgdW5kZXNpcmFibGUgdW5kZXIgY29uZGl0aW9ucyBmb3IgdGhhdCBub3Qg
dG8gcnVuIGZvciB0aG9zZSB0dXBsZXMgdGhhdCBhcmUgYWxyZWFkeSBnb25l
Lg0KDQpXZWxsLCBub3QgZmlyaW5nIHRoZSB0cmlnZ2VyIHdvdWxkIGJlIHBy
ZXR0eSBiYWQgaW4gc29tZSBjYXNlcyB0b28uICBGb3INCmluc3RhbmNlIGlm
IHlvdSdyZSB0cnlpbmcgdG8gbG9nIHVwZGF0ZXMgaW4gYSBoaXN0b3J5IHRh
YmxlLCB5b3UnZCBub3QNCndhbnQgdG8gbWlzcyB1cGRhdGVzIGp1c3QgYmVj
YXVzZSB0aGV5IHdlcmUgaW1tZWRpYXRlbHkgb2Jzb2xldGVkLg0KDQpMb29r
aW5nIGFnYWluIGF0IHlvdXIgZXhhbXBsZSwgdGhhdCdzIGV4YWN0bHkgd2hh
dCB5b3VyIHRyaWdnZXIgaXMNCmRvaW5nLCBpc24ndCBpdD8gIFdoeSBpbiB0
aGUgd29ybGQgaGFzIHlvdXIgaGlzdG9yeSB0YWJsZSBnb3QgYW4gRksNCmJh
Y2sgdG8gdGhlIGxpdmUgdGFibGVzPyAgVGhhdCBwcmVzdW1lcyB0aGF0IHlv
dSdsbCBuZXZlciBkZWxldGUgYW55DQpvYmplY3RzIC4uLiBvciB0aGF0IHlv
dSdyZSB3aWxsaW5nIHRvIGxvc2UgYWxsIGhpc3RvcnkgYWJvdXQgdGhlbQ0K
YXMgc29vbiBhcyB0aGV5J3JlIGRlbGV0ZWQsIHdoaWNoIHNlZW1zIGEgcHJl
dHR5IG9kZCBjaG9pY2UuDQoNCiAgICAgICAgICAgICAgICAgICAgICAgIHJl
Z2FyZHMsIHRvbSBsYW5lDQoNCg==

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: Rudolf Leitgeb
Date:
Subject: Re: BUG #4397: crash in tab-complete.c