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