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
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? |