문서에는 before -> after -> before -> after 순서인데
=> DELETE FROM ttest;
INFO: trigf (fired before): there are 2 rows in ttest
INFO: trigf (fired after ): there are 1 rows in ttest
INFO: trigf (fired before): there are 1 rows in ttest
INFO: trigf (fired after ): there are 0 rows in ttest
^^^^^^
remember what we said about visibility.
실행하면 before -> before -> after -> after 로 되서요 저만 그런건지.....
vela=# delete from ttest;
정보: trigf (fired before): there are 2 rows in ttest
정보: trigf (fired before): there are 1 rows in ttest
정보: trigf (fired after ): there are 0 rows in ttest
정보: trigf (fired after ): there are 0 rows in ttest
DELETE 2
vela=#
|