> 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/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services