Re: [HACKERS] Statement Triggers. Ideas & help.

At 09:55 17/08/99 +0800, Vadim Mikheev wrote:
>F J Cuberos wrote:
>> 
>> Forget the problem with Executeplan, I was getting the syslogs and stdour
>> messages in the same screen; SO DOUBLE!!!!.
>> 
>> With statement triggers (and defined in SQL3 too) will be interesting to
>> access OLD and NEW values of modified tables. How can be implemented? It´s
>> possible to use MVCC for this?
>
>MVCC uses t_xmin/t_xmax to decide what's visible to transaction.
>For OLD/NEW you will have to analyze t_cmin/t_cmax as well.

FWIW, Dec (Oracle) Rdb does not allow access to OLD & NEW in statement
triggers; if you want the rows, you have to write 'for each row' triggers.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: +61-03-5367 7422            |                 _________  \
Fax: +61-03-5367 7430            |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/