Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger in transaction - Mailing list pgsql-general

From Tom Lane
Subject Re: Trigger in transaction
Date
Msg-id 3067.1053834109@sss.pgh.pa.us
Whole thread Raw
In response to Trigger in transaction  (Daniel Carlsson <daniel.carlsson@gimlisoft.se>)
List pgsql-general
Tree view 
Daniel Carlsson <daniel.carlsson@gimlisoft.se> writes:
> I can't figure out why the changedate is not updated.

CURRENT_TIMESTAMP doesn't advance inside a transaction.  See
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Transaction Triggers!
Next
From: Tom Lane
Date:
Subject: Re: Iterating through individual fields of OLD/NEW records in plpgsql trigger