Re: Tables are not being updated Properly through Trigger - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: Tables are not being updated Properly through Trigger
Date
Msg-id 20050819050231.GA11416@webserv.wug-glas.de
Whole thread Raw
In response to Tables are not being updated Properly through Trigger  ("Venkatesh Krishnamurthy" <venkatesh.krishnamurthy@valtech.co.in>)
List pgsql-sql
am  15.08.2005, um 18:07:23 +0530 mailte Venkatesh Krishnamurthy folgendes:
> 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 ?

Nobody can guess your problem without the source-code of your trigger an
a simple example. Can you poste this on http://rafb.net/paste/ and tell
us then the link?


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    === 


pgsql-sql by date:

Previous
From: "Venkatesh Krishnamurthy"
Date:
Subject: Tables are not being updated Properly through Trigger
Next
From: "Marc G. Fournier"
Date:
Subject: pl/PgSQL: Samples doing UPDATEs ...