On 17 June 2015 at 13:52, Kevin Grittner <kgri...@ymail.com> wrote: > Filipe Pina <filipe.p...@impactzero.pt> wrote: > > > if drop the foreign key constraint on stuff_ext table there are > > no failures at all… > > It is my recollection that we were excluding the queries used to > enforce referential integrity constraints from the conflict > tracking, so I am surprised you are seeing this. What is the exact > version you are using (as reported by the version() function)? >
I don't see any mechanism for excluding anything from serializable checks, so I can't see how that would work. I can't find any mention of serializability concerns in the RI code itself. AFAIK it would be strange to exclude FK checks from serializability checks, since they represent a valid observation of an intermediate state. Mat Views are excluded but I don't understand why that should be the case. There is no documented explanation. -- Simon Riggs http://www.2ndQuadrant.com/ <http://www.2ndquadrant.com/> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
