Search Postgresql Archives

Re: How to avoid UPDATE on same data in table ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How to avoid UPDATE on same data in table ?
From: Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>
Date: Sun, 2 Feb 2020 14:37:30 +0100
In-reply-to: <1a25799e60c79c65575f6e6375c96a52@stz-bg.com>
References: <1a25799e60c79c65575f6e6375c96a52@stz-bg.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.4.1



Am 02.02.20 um 10:24 schrieb Condor:

CREATE TRIGGER last_changes
  BEFORE UPDATE ON status_table
  FOR EACH ROW
WHEN (OLD.* IS DISTINCT FROM NEW.*)


try to exclude the column lastchange from the comparison.


Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How to avoid UPDATE on same data in table ?
  - From: Andreas Kretschmer

References:
- How to avoid UPDATE on same data in table ?
  - From: Condor

Prev by Date: How to avoid UPDATE on same data in table ?
Next by Date: Re: How to avoid UPDATE on same data in table ?
Previous by thread: How to avoid UPDATE on same data in table ?
Next by thread: Re: How to avoid UPDATE on same data in table ?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux