pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sean K. Sell <sean@nist.gov>
To: pgsql-admin@postgresql.org
Subject: Re: update in rule
Date: Wed, 07 Nov 2001 07:43:16 -0500
Message-ID: <3BE92C64.579985CA@nist.gov> (raw)
References: <vqobsj6qiw5.fsf@brevent.imag.fr>
	<Pine.BSF.4.21.0110171159030.23020-100000@megazone23.bigpanda.com>
	<20011107115249.V7681@blue.alter.pl>

If you do the try to set the timestamp AFTER the Update the record is already written and your change would
not be refected. THAT is the difference between BEFORE and AFTER as I understand it.


Radoslaw Stachowiak wrote:

> *** Stephan Szabo <sszabo@megazone23.bigpanda.com> [Wednesday, 17.October.2001, 12:04 -0700]:
> > create function adresses_trigger() returns opaque as '
> > begin
> >  NEW.date_maj := now();
> >  return NEW;
> > end;' language 'plpgsql';
> > create trigger tr before update on adresses for each row execute
> >  procedure adresses_trigger();
>
> why sould I use before (instead of after)?
> isnt it a little dangerous in transactions? /hope not/
>
> I know difference between both forms. The question is rather about if
> timestamp updating shouldnt be run AFTER update which I think is closer
> to a real world situations (of course evth vary). But maybe there are
> some probles with after, which I dont know about?
>
> Just being curious...
>
> --
> radoslaw.stachowiak.........................................http://alter.pl/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



view thread (8+ messages)  latest in thread

Message-ID: <3BE92C64.579985CA@nist.gov>
Permalink:  ../3BE92C64.579985CA@nist.gov/
Also on:    postgresql.org/message-id/3BE92C64.579985CA@nist.gov

 · 

reply

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: sean@nist.gov, pgsql-admin@postgresql.org
  Subject: Re: update in rule
  In-Reply-To: <3BE92C64.579985CA@nist.gov>

* 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