Skip site navigation (1) Skip section navigation (2)

Re: ADD FOREIGN KEY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: Christopher Browne <cbbrowne(at)acm(dot)org>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: ADD FOREIGN KEY
Date: 2003-10-01 22:43:43
Message-ID: 10345.1065048223@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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

In response to

pgsql-hackers by date

Next:From: Maksim LikharevDate: 2003-10-01 22:50:04
Subject: Re: FreeSpaceMap hashtable out of memory
Previous:From: Tom LaneDate: 2003-10-01 22:35:55
Subject: Re: Thoughts on maintaining 7.3

pgsql-general by date

Next:From: Rick SeegerDate: 2003-10-01 22:58:50
Subject: Can anyone recommend a good PostGres admin tool?
Previous:From: Christopher BrowneDate: 2003-10-01 19:04:37
Subject: Re: ADD FOREIGN KEY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group