From: A. Kretschmer <akretschmer@despammed.com>
To: pgsql-sql@postgresql.org
Subject: Re: Tables are not being updated Properly through Trigger
Date: Fri, 19 Aug 2005 07:02:31 +0200
Message-ID: <20050819050231.GA11416@webserv.wug-glas.de> (raw)
In-Reply-To: <407594B13C4D1D479215D7225A4A99B949702D@INBLR-EX01.valtechindia.com>
References: <407594B13C4D1D479215D7225A4A99B949702D@INBLR-EX01.valtechindia.com>
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 ===
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: akretschmer@despammed.com
Subject: Re: Tables are not being updated Properly through Trigger
In-Reply-To: <20050819050231.GA11416@webserv.wug-glas.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox