From: | "incheol yang" <zoar(at)paran(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1953: trigger action on delete |
Date: | 2005-10-11 09:08:47 |
Message-ID: | 20051011090847.03117F12D2@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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?
~
From | Date | Subject | |
---|---|---|---|
Next Message | Antonio Molina | 2005-10-11 12:27:15 | BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy') |
Previous Message | Klint Gore | 2005-10-11 05:27:00 | Re: BUG #1947: Enhancement Request - CONCAT() function |