Search Postgresql Archives

Re: Help with restoring a dump in Tar format? (dependencies/ordering)

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

 



On Mon, Jun 5, 2017 at 5:40 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
​i​
ndeed, any sort of constraint that invokes a function call which looks at other tables could later be invalidated if those other tables change, and postgres would be none the smarter.   the same goes for trigger based checks.

​Yes.  I could imagine a new kind of "multi-referential trigger" that would specify all relations it touches and the function to fire when each of them is updated.  While you'd still have to write the functions correctly it would at least allow one to explicitly model the multi-table dynamic in pg_catalog.  Lacking that CHECK is no worse than TRIGGER and we've decided to say "use triggers".

David J.​

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[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