Hackers; as per $subject... We have an FK defined on a table large enough and 24x7 as to make a redefining of same constraint a painful solution.
Ran into a case where defining as deferrable initially immediate and just running one batch job with deferred firing would solve a concurrency problem that we discovered. Grabbing a quick exclusive lock on the 2 related tables would not be a problem if same might help avoid bad side-effects. Developers are already working on a chunking solution to avoid the long-running transaction that gave rise to this but I'd like to consider this if it's not risky. Comments? -- Jerry Sievers Postgres DBA/Development Consulting e: [email protected] p: 312.241.7800 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
