Re: BUG #1953: trigger action on delete

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: incheol yang <zoar(at)paran(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1953: trigger action on delete
Date: 2005-10-13 02:24:53
Message-ID: 200510130224.j9D2Or401994@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> The triggers are fired in alphabetical order, check the names of the triggers...

It isn't so much the alphabetical order, since there is only one
trigger, but the concept that we now group all the _before_ triggers
before the _after_ triggers. I have updated the sample output to
reflect our new trigger fire ordering.

Thanks for the report.

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

Jaime Casanova wrote:
> On 10/11/05, incheol yang <zoar(at)paran(dot)com> wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference: 1953
> > Logged by: incheol yang
> > Email address: zoar(at)paran(dot)com
> > PostgreSQL version: 8.0.4
> > Operating system: fedora core 4
> > Description: trigger action on delete
> > Details:
> >
> > kernel version 2.6.13-1.1526_FC4
> >
> > CPU AMD ATHLON 1G Hz
> > kernel version 2.6.13-1.1526_FC4
> >
> > rpm postgresql-8.0.4-2.FC4.1
> >
> > db encoded by UNICODE
> >
> > _int.sql contrib was appended
> >
> > source code was copied by mouse.
> >
> > cc (GCC) 4.0.1 20050727 (Red Hat 4.0.1-5)
> >
> > cc -fpic -c trigf.c -I/usr/include/pgsql/server
> > cc -shared -o trigf.so trigf.o
> >
> > ===============================================================
> > 8.0.4 Document chapter 32.4
> > ===============================================================
> >
> > INSERT, INSERT INTO, UPDATE commands had same output, but
> >
> >
> > => DELETE FROM ttest;
> > INFO: trigf (fired before): there are 2 rows in ttest
> > INFO: trigf (fired after ): there are 1 rows in ttest
> > INFO: trigf (fired before): there are 1 rows in ttest
> > INFO: trigf (fired after ): there are 0 rows in ttest
> > ^^^^^^
> > fired before -> after -> before -> after
> >
> > ===============================================================
> > My output
> > ===============================================================
> >
> > => DELETE FROM ttest;
> > INFO: trigf (fired before): there are 2 rows in ttest
> > INFO: trigf (fired before): there are 1 rows in ttest
> > INFO: trigf (fired after ): there are 0 rows in ttest
> > INFO: trigf (fired after ): there are 0 rows in ttest
> >
> > fired before -> before -> after -> after
> >
> >
> > Is this my fault?
> >
>
>
> --
> regards,
> Jaime Casanova
> (DBA: DataBase Aniquilator ;)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-10-13 03:04:38 Re: BUG #1953: trigger action on delete
Previous Message Michael Fuhr 2005-10-13 00:56:51 Re: Problem with COPY in 8.0.3