pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTables are not being updated Properly through Trigger
2+ messages / 2 participants
[nested] [flat]
* Tables are not being updated Properly through Trigger
@ 2005-08-15 12:37 Venkatesh Krishnamurthy <venkatesh.krishnamurthy@valtech.co.in>
0 siblings, 1 reply; 2+ messages in thread
From: Venkatesh Krishnamurthy @ 2005-08-15 12:37 UTC (permalink / raw)
To: pgsql-sql
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 ?
Thanks,
Venkatesh
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Tables are not being updated Properly through Trigger
@ 2005-08-19 05:02 A. Kretschmer <akretschmer@despammed.com>
parent: Venkatesh Krishnamurthy <venkatesh.krishnamurthy@valtech.co.in>
0 siblings, 0 replies; 2+ messages in thread
From: A. Kretschmer @ 2005-08-19 05:02 UTC (permalink / raw)
To: 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 ===
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-08-19 05:02 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-15 12:37 Tables are not being updated Properly through Trigger Venkatesh Krishnamurthy <venkatesh.krishnamurthy@valtech.co.in>
2005-08-19 05:02 ` A. Kretschmer <akretschmer@despammed.com>
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