> 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 <[EMAIL PROTECTED]> wrote: > > > > The following bug has been logged online: > > > > Bug reference: 1953 > > Logged by: incheol yang > > Email address: [EMAIL PROTECTED] > > 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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
