Multiple TRIGGERs and OLD versus NEW "records"

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Multiple TRIGGERs and OLD versus NEW "records"
Date: 2007-03-14 11:13:36
Message-ID: 87ps7cjcwv.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi!

(Consider these UPDATE triggers)

I can't test this for now since I'm not with a test database handy for now,
but I was thinking on what happens to OLD and NEW when running multiple
triggers.

For example, for the first trigger OLD is the equivalent to the data that is
stored at the database already, NEW is the data I'm sending to the database.
If I change some column -- e.g. fill in some automatic calculated column or a
timestamp column --, when I run the second trigger will OLD be the data stored
at the database already or will it be affected by the NEW data returned from
the previous trigger?

I know that NEW propagates, but does OLD change? I suppose not and I can't
confirm that now... If anyone has the answer, sharing would be nice. If I
don't get any answer, I'll test and post the results later. :-)

TIA,
--
Jorge Godoy <jgodoy(at)gmail(dot)com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2007-03-14 11:49:20 Re: Statement logging
Previous Message A. Kretschmer 2007-03-14 09:44:07 Re: Statement logging