Skip site navigation (1) Skip section navigation (2)

Tables are not being updated properly through Trigger

From: "Venkatesh Krishnamurthy" <venkatesh(dot)krishnamurthy(at)valtech(dot)co(dot)in>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Tables are not being updated properly through Trigger
Date: 2005-08-15 13:02:10
Message-ID: 407594B13C4D1D479215D7225A4A99B949702F@INBLR-EX01.valtechindia.com (view raw or flat)
Thread:
Lists: pgsql-novice
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


Responses

pgsql-novice by date

Next:From: Saranya SivakumarDate: 2005-08-15 14:10:36
Subject: restart postgres 7.3.2 problem
Previous:From: Steve PoeDate: 2005-08-15 09:36:45
Subject: Re: Uploading and loading

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group