Re: How to avoid UPDATE on same data in table ? - Mailing list pgsql-general

From Condor
Subject Re: How to avoid UPDATE on same data in table ?
Date
Msg-id 62ebca7bbcd3e89c00d5db9fd8f35479@stz-bg.com
Whole thread Raw
In response to Re: How to avoid UPDATE on same data in table ?  (Andrei Zhidenkov <andrei.zhidenkov@n26.com>)
List pgsql-general
On 03-02-2020 10:29, Andrei Zhidenkov wrote:
> Have you tried to use built-in suppress_redundant_updates_trigger[1]
> for this?
> 
> 1. https://www.postgresql.org/docs/12/functions-trigger.html
> 

No,
solution point me Adrian Klaver it's working for me. I look at page, but 
this probably is build in function and can't be changed.
In my case I need to change lastchange column to know which row is 
changed and when.

Regards,
HS



pgsql-general by date:

Previous
From: Steven Lembark
Date:
Subject: Re: performance of loading CSV data with COPY is 50 times fasterthan Perl::DBI
Next
From: Ravi Krishna
Date:
Subject: Re: performance of loading CSV data with COPY is 50 times faster thanPerl::DBI