Sorry, I can not understand what you were testing here. ---------------------------------------------------------------------------
incheol yang 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? > > ~ > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- 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 2: Don't 'kill -9' the postmaster
