| 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: | Whole Thread | Raw Message | 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 |