> On 20 Jul 2017, at 5:26 AM, Hannes Erven <han...@erven.at> wrote:
> 
> Hi Glen,
> 
> 
>> I'd like to enforce that in a transaction, after a couple inserts &  > 
>> updates, a particular column has continuous values like 1, 2, 3, and 
> > never any gaps. Is it possible to do?> > I gave a concrete example here: > 
> > https://stackoverflow.com/questions/45187113 didn't get any answers yet.
> I've posted a comment to SO; basically what I'm saying is yes, use a 
> transaction constraint trigger to enforce your requirement.
> 
> This previous question has an example of such a trigger:
> 
> https://stackoverflow.com/a/37277421/1980653
> 
> 
> HTH & best regards
> 
>       -hannes

Using a trigger sounds like the right approach. I’ll try it out. Thanks guys.

Hannes, thanks for posting an answer to SO, I’ve accepted it. :)

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to