Postgres Pro
Downloads
Home   >   mailing lists

Re: Detecting changes to certain fields in 'before update' trigger functions - Mailing list pgsql-general

From Tom Lane
Subject Re: Detecting changes to certain fields in 'before update' trigger functions
Date
Msg-id 23157.1228152296@sss.pgh.pa.us
Whole thread Raw
In response to Re: Detecting changes to certain fields in 'before update' trigger functions  (Sebastian Tennant <sebyte@smolny.plus.com>)
List pgsql-general
Tree view 
Sebastian Tennant <sebyte@smolny.plus.com> writes:
> I sometimes think this kind of gotcha is purposely buried, or not
> addressed at all, in order to force users to read the manual.

Where exactly do you think we should document it, if not in the manual?
In any case it's SQL-standard behavior that any book about SQL will
tell you.

            regards, tom lane

pgsql-general by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: Detecting changes to certain fields in 'before update' trigger functions
Next
From: Owen Hartnett
Date:
Subject: pg_dump restore as transaction?