strange behavior on 8.1

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: strange behavior on 8.1
Date: 2005-11-17 15:22:48
Message-ID: 1132240968.10890.327.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I have observed a strange behavior on 8.1 of an insert statement into a
temporary table done from a delete trigger.
I've attached a test case.
Observe that the NOTICE saying the rows were inserted occurs all 5 times
for the 8.0.3 server and only for the first 2 times for the 8.1
installation, and all further runs of the flush_test function yield no
successful insert...
Might worth to note that the 8.0.3 installation has 2 patches, one to
disallow the locking of parent keys in foreign key triggers, and another
one which changes time-stamp rounding behavior to "truncate".

Any ideas why this happens ?

Cheers,
Csaba.

Attachment Content-Type Size
flush_trigger_8_1.txt text/plain 3.7 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F. O'Connell 2005-11-17 15:31:58 Re: Performance of a view
Previous Message Lincoln Yeoh 2005-11-17 15:11:25 Re: PREPARE TRANSACTION and webapps