Re: Transactional issue that begs for explanation
| От | Thom Brown |
|---|---|
| Тема | Re: Transactional issue that begs for explanation |
| Дата | |
| Msg-id | AANLkTinam1efvi8=kD+mS+hVf6rwbsaYAY+NaQbqCH9B@mail.gmail.com обсуждение исходный текст |
| Ответ на | Transactional issue that begs for explanation (Mladen Gogala <mladen.gogala@vmsinfo.com>) |
| Список | pgsql-novice |
On 10 September 2010 11:27, Mladen Gogala <mladen.gogala@vmsinfo.com> wrote: > Thom Brown wrote: >> >> This is quite odd. I've done exactly the same thing on 8.4.4 Gentoo >> x64 and it returns the expected result so I haven't been able to >> recreate it. What does the table contain after that series of events? >> >> > > Oh, the content is correct, 4 records are modified, 5,10,15 and 20 have all > value 'DIV5'. I've been bitten by triggers before so I am testing the > trigger behavior. The good news is that "before update" trigger doesn't fire > twice, as is the case with Oracle. BTW, is there any simpler method to > simulate DBMS_OUTPUT, other than using plperlu the way I did? Please reply to all so everyone else can see your response. :) (list copied in again for this message) But I personally don't know of the best way to produce the logging you're after. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935
В списке pgsql-novice по дате отправления: