Re: Tables are not being updated properly through Trigger

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Venkatesh Krishnamurthy <venkatesh(dot)krishnamurthy(at)valtech(dot)co(dot)in>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Tables are not being updated properly through Trigger
Date: 2005-08-19 07:30:26
Message-ID: 1124436626.12407.23.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, 2005-08-15 at 18:32 +0530, Venkatesh Krishnamurthy wrote:
> 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 ?

You need to show the trigger definitions and the definition of the
function(s) that those triggers run. You should also state what version
of PostgreSQL you are using.

Oliver

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-08-19 14:46:23 Re: Intsall 8.03 on Redhat ES 3
Previous Message Stuart Bishop 2005-08-19 06:40:43 Re: how to rename an unnamed uniqueness constraint?