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

From: Condor <condor(at)stz-bg(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to avoid UPDATE on same data in table ?
Date: 2020-02-03 16:24:21
Message-ID: 62ebca7bbcd3e89c00d5db9fd8f35479@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2020-02-03 16:57:14 Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI
Previous Message Steven Lembark 2020-02-03 16:02:59 Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI