strange behavior on 8.1

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема strange behavior on 8.1
Дата
Msg-id 1132240968.10890.327.camel@coppola.muc.ecircle.de
обсуждение исходный текст
Ответы Re: strange behavior on 8.1  (Csaba Nagy <nagy@ecircle-ag.com>)
Re: strange behavior on 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.


Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: PREPARE TRANSACTION and webapps
Следующее
От: "Thomas F. O'Connell"
Дата:
Сообщение: Re: Performance of a view