Re: BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key

From: Stephen Cuppett <Stephen(dot)Cuppett(at)sas(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key
Date: 2008-09-03 16:15:23
Message-ID: F62CC1C9DC2ABC4A8D986537A79D324F0AA4AB2F33@MERCMBX14.na.sas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I can upload the whole schema someplace, or is attaching a few files here okay?

Noticed that if I delete from the feature level, I do not hit the problem.

---------------------------------------------------------------------------------------
Stephen Cuppett
SAS® Certified Advanced Programmer for SAS9®
Tel: +1 919 531 0659 ▪ Stephen(dot)Cuppett(at)sas(dot)com
www.sas.com

SAS® … THE POWER TO KNOW®

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, September 03, 2008 11:45 AM
To: Stephen Cuppett
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key

"Stephen Cuppett" <stephen(dot)cuppett(at)sas(dot)com> writes:
> Description: Trigger event fired "UPDATE" when "DELETE" happening via
> foreign key

You're going to need to show a complete example if you want any help
with this. (My bet is that you've overlooked a trigger someplace...)

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-09-03 16:24:24 Re: BUG #4396: Trigger event fired "UPDATE" when "DELETE" happening via foreign key
Previous Message Tom Lane 2008-09-03 15:48:47 Re: BUG #4397: crash in tab-complete.c