Re: Before/After trigger sequencing question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
Cc: pgsql-general(at)postgresql(dot)org (pgsql general list)
Subject: Re: Before/After trigger sequencing question
Date: 2004-07-28 04:36:23
Message-ID: 17051.1090989383@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike Nolan <nolan(at)gw(dot)tssi(dot)com> writes:
> I have a before insert trigger that updates a value in another table.

> It appears that I cannot depend upon that update having taken place
> in an after insert trigger on the first table. (The one with the insert.)

This seems a tad improbable, not to say impossible. Concrete example,
please?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2004-07-28 04:37:17 Re: altering a table to set serial function
Previous Message Robby Russell 2004-07-28 04:20:02 Re: Trigger on Postgres for tables syncronization