Re: On exclusion constraints and validity dates - Mailing list pgsql-general

From Adrian Klaver
Subject Re: On exclusion constraints and validity dates
Date
Msg-id 55d5e0db-f80a-4253-8c21-9b7b6c6a2f4d@aklaver.com
Whole thread Raw
In response to On exclusion constraints and validity dates  (Justin Giacobbi <jgiacobbi@optionmetrics.com>)
List pgsql-general
On 8/22/24 11:13, Justin Giacobbi wrote:
> Hello,
> 

> Currently I’m looking at working around this in the application or in a 
> stored procedure/insert trigger that is essentially the same logic. 
> Whichever seems easier to maintain.
> 
> Advice on how to submit a feature request, or maybe a better workaround 
> that I haven’t discovered would be most welcome. What would be even more 
> welcome is someone with insight into these pieces of the program that 
> can tell me if I’d be biting off more than I can chew (or violating a 
> principle) trying to submit one of the three options above as a feature.

Merge?:

https://www.postgresql.org/docs/current/sql-merge.html

> 
> Thank you
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: ERROR: could not open relation with OID XXXX
Next
From: Marcelo Zabani
Date:
Subject: Re: ERROR: could not open relation with OID XXXX