On Tue, 10 May 2011 14:29:48 -0400, Vick Khera <vi...@khera.org> wrote:
> in recent versions of postgres, there is a "replication" mode designed > specifically for replication software to disable FK's and other > triggers. Perhaps investigate that. > the other option is to make your FK's deferrable, and do all your > delete in one big transaction with the FK checks deferred. not sure > if that will help. > either that, or order your deletes and loads in a way such that the > FKs remain satisfied. unless you have circular dependencies, this > should be possible. Excellent, this last suggestion was actually a very simple and efficient solution. However, I got curious about the deferrable FK's, which might make this and other scripts more flexible. Thanks everyone for your feedback, -- Seb -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
