Re: FOREIGN KEY ... CONCURRENTLY - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: FOREIGN KEY ... CONCURRENTLY
Date
Msg-id 20140130020408.GB10723@eldon.alvh.no-ip.org
Whole thread Raw
In response to FOREIGN KEY ... CONCURRENTLY  (David Fetter <david@fetter.org>)
List pgsql-hackers
David Fetter wrote:

>     2) Is there another way to solve the problem of adding a foreign
>     key constraint that points at a busy table?

Add it as NOT VALID and do a later VALIDATE CONSTRAINT step, after the
patch to reduce lock levels for ALTER TABLE goes in, perhaps?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Suspicion of a compiler bug in clang: using ternary operator in ereport()
Next
From: Bruce Momjian
Date:
Subject: Re: updated emacs configuration