Re: Order of enforcement of CHECK constraints? - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: Order of enforcement of CHECK constraints?
Date
Msg-id CAFcNs+pR7tnJ5_gL8rU6LPYNFgsWuzvb6q9LpX=5duSaKJycUw@mail.gmail.com
Whole thread
In response to Re: Order of enforcement of CHECK constraints?  (Peter Geoghegan <pg@heroku.com>)
Responses Re: Order of enforcement of CHECK constraints?
List pgsql-hackers

On Fri, Mar 20, 2015 at 4:19 PM, Peter Geoghegan <pg@heroku.com> wrote:
>
> On Fri, Mar 20, 2015 at 12:15 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > We could fix it by, say, having CheckConstraintFetch() sort the
> > constraints by name after loading them.
>
>
> What not by OID, as with indexes? Are you suggesting that this would
> become documented behavior?
>
 
I think they should be executed in alphabetical order like triggers.

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Order of enforcement of CHECK constraints?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Remove fsync ON/OFF as a visible option?