postgresql function not raising exception...

How to avoid circular relations in postgres using cycle detection...