Re: pg_dump restore time and Foreign Keys

On Mon, 2008-06-09 at 11:33 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > On Mon, 2008-06-09 at 10:57 -0400, Tom Lane wrote:
> >> Ah, finally a useful comment.  I think it might be possible to do an
> >> "add FK concurrently" type of command that would take exclusive lock
> 
> > That's good, but it doesn't solve the original user complaint about
> > needing to re-run many, many large queries to which we already know the
> > answer.
> 
> No, we are running a large query to which the user *thinks* he knows the
> answer.  There are any number of reasons why he might be wrong.

Of course. I should have said "to which we already know the answer" to
indicate I'm passing on others' criticisms of us.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support