Bruce Momjian wrote: > > Sorry, I can not understand what you were testing here.
I see now. I am running some tests to try to reproduce it. --------------------------------------------------------------------------- > > --------------------------------------------------------------------------- > > 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 > -- 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
