The following bug has been logged online:
Bug reference: 5576
Logged by: y.y.chen
Email address: segma(dot)yychen(at)msa(dot)hinet(dot)net
PostgreSQL version: 8.4.x
Operating system: WINDOWS-XP
Description: Boolean operation should not be Complete boolean
evaluation
Details:
When I run SQL -scripts in trigger/PlpgSQL:
IF (TG_OP = 'INSERT') OR (old.size<>new.size) THEN
.......
END IF;
It raise a exception: RECORD old never be defined,
while TG_OP is 'INSERT'.
--------------------------------
It is happen in 8.3.11,8.4.1~8.4.4-1
But 9.0.0.beta 3 is OK!