Re: ADD FOREIGN KEY

Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> db=> SET disable-fk-verification = true;
> ERROR: "disable-fk-verification" can only be set in single user mode

I don't really see the point of such a restriction. Restricting the
system to a single user has nothing to do with making
disable-fk-verification more safe. It would simply be an artificial
restriction making the feature harder to use.

Also, not very long ago we were speculating about the possible value of
parallel restore processes --- while I recall being unimpressed with the
likely gains, I wouldn't want to put a permanent kibosh on the idea by
adopting a philosophy that restores are supposed to be done in
single-user mode.

regards, tom lane