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? >
The triggers are fired in alphabetical order, check the names of the triggers... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
