Skip site navigation (1) Skip section navigation (2)

BUG #1953: trigger action on delete

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 (view raw or flat)
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?

~

Responses

pgsql-bugs by date

Next:From: Antonio MolinaDate: 2005-10-11 12:27:15
Subject: BUG #1954: Bug in to_date('09-10-2005', 'dd-mm-yyyy')
Previous:From: Klint GoreDate: 2005-10-11 05:27:00
Subject: Re: BUG #1947: Enhancement Request - CONCAT() function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group