Re: Foreign key locks
Vivek Khera <khera@kcilink.com>
From: Vivek Khera <khera@kcilink.com>
To: pgsql-general@postgresql.org
Date: 2004-09-02T20:59:46Z
Lists: pgsql-general
>>>>> "SS" == Stephan Szabo <sszabo@megazone.bigpanda.com> writes: SS> You really should just need to drop the constraints and recreate them, not SS> the entire schema. So do I want to do deferred checks on all transactions, or just some/one of them? I'm assuming that if the advice is to make them initally deferred that means all of them, but I wanted to be sure. Thanks! -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/