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