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 |
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 |