Date: Fri, 19 Aug 2005 07:02:31 +0200
From: "A. Kretschmer" <akretschmer@despammed.com>
To: pgsql-sql@postgresql.org
Subject: Re: Tables are not being updated Properly through Trigger
Message-ID: <20050819050231.GA11416@webserv.wug-glas.de>
Mail-Followup-To: "A. Kretschmer" <akretschmer@despammed.com>,
	pgsql-sql@postgresql.org
References: 
 <407594B13C4D1D479215D7225A4A99B949702D@INBLR-EX01.valtechindia.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <407594B13C4D1D479215D7225A4A99B949702D@INBLR-EX01.valtechindia.com>
User-Agent: mutt-ng 1.5.9i (Linux)

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