BUG #1274: Trigger sequence incorrect

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1274: Trigger sequence incorrect
Date: 2004-09-30 06:06:10
Message-ID: 20040930060610.C7A645A106B@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1274
Logged by: shancheng

Email address: sd_shancheng(at)hotmail(dot)com

PostgreSQL version: 8.0 Beta

Operating system: Fedora 2

Description: Trigger sequence incorrect

Details:

The problem happens when I was trying the example that is described in
"PostgreSQL 8.0.0beta1 Documentation, chapt 33.4 --- A Complete Example".

At the last step, as the document says, the result should be:
=> 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
DELETE 2

But what i see is that:
test=# DELETE FROM ttest;
NOTICE: trigf (fired before): there are 2 tuples in ttest
NOTICE: trigf (fired before): there are 1 tuples in ttest
NOTICE: trigf (fired after ): there are 0 tuples in ttest
NOTICE: trigf (fired after ): there are 0 tuples in ttest
DELETE 2

The execution sequence of the triggers is incorrect.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Markus Bertheau 2004-09-30 08:16:28 Re: BUG #1271: Installation problems (cannot execute
Previous Message yoursoft@freemail.hu 2004-09-30 03:17:47 Bug with 8900 users