Tables are not being updated Properly through Trigger

<p align="LEFT"><span lang="en-us"><font face="Arial" size="2">We have written a trigger</font></span><span
lang="en-us"></span><spanlang="en-us"> <font face="Arial" size="2">on insertion</font><font face="Arial"
size="2"></font></span><spanlang="en-us"></span><span lang="en-us"> <font face="Arial" size="2">which is supposed
to</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2"> update 3 tables with new
data.</font> <fontface="Arial" size="2"></font></span><span lang="en-us"></span><span lang="en-us"> <font face="Arial"
size="2">W</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2">e are seeing a</font>
<fontface="Arial" size="2">weird</font><font face="Arial" size="2"> thing happening</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2"> with Postgres</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2">, i.</font></span><span lang="en-us"></span><span
lang="en-us"><fontface="Arial" size="2">e.  I</font><font face="Arial" size="2">f we have 4 records to be
updated</font><font face="Arial" size="2">on insertion trigger, postgres updates the first 3 records in the 3 tables
properly,and when it comes to final record, it is updating only the first 2 tables in sequence and is skipping the
3</font></span><spanlang="en-us"></span><span lang="en-us"><sup></sup><sup><font face="Arial"
size="2">rd</font></sup></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial"
size="2"></font></span><spanlang="en-us"></span><span lang="en-us"> <font face="Arial" size="2">table.</font> <font
face="Arial"size="2"> S</font><font face="Arial" size="2">o, we are ending up with</font> <font face="Arial"
size="2">theimproper data. Any body has come across such an issue earlier or can anybody tell us whats happening here
?</font></span><spanlang="en-us"></span><span lang="en-us"></span><br /><p align="LEFT"><span lang="en-us"></span><a
name=""><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2">Thanks,</font></span></a><span
lang="en-us"></span><spanlang="en-us"></span><p align="LEFT"><span lang="en-us"><font face="Arial"
size="2">Venkatesh</font></span><palign="LEFT"><span lang="en-us"></span>