> On 20 Jul 2017, at 5:26 AM, Hannes Erven <hannes@xxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
