We have written a trigger on insertion which is supposed to update 3 tables with new data. We are seeing a weird thing happening with Postgres, i.e. If we have 4 records to be updated 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 3rd table. So, we are ending up with the improper data. Any body has come across such an issue earlier or can anybody tell us whats happening here ?
Thanks,
Venkatesh