Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] UPDATE column without FK fires other FK triggers constraint check - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] UPDATE column without FK fires other FK triggers constraint check
Date
Msg-id 2782.1500502476@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] UPDATE column without FK fires other FK triggers constraint check  (Luca Looz <luca.looz92@gmail.com>)
List pgsql-general
Tree view 
Luca Looz <luca.looz92@gmail.com> writes:
> Thanks for the explanation!
> Can these checks be implemented or the data needed is not there and adding
> it will only add an overhead for the majority of use cases?

It's hard to see how to do much better than we're doing without storing
more data on-disk than is there now.  Whether that would be a good
tradeoff is dubious.

            regards, tom lane

pgsql-general by date:

Previous
From: Evan Martin
Date:
Subject: Re: [GENERAL] Why would log_lock_waits affect a query plan?
Next
From: Matthew Byrne
Date:
Subject: Re: [GENERAL] Support for \u0000?