Re: pg_restore problems and suggested resolution - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: pg_restore problems and suggested resolution
Date
Msg-id 402DA11C.4080800@familyhealth.com.au
Whole thread Raw
In response to Re: pg_restore problems and suggested resolution  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_restore problems and suggested resolution  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
> As an implementation issue, I wonder why these things are hacking
> permanent on-disk data structures anyway, when what is wanted is only a
> temporary suspension of triggers/rules within a single backend.  Some
> kind of superuser-only SET variable might be a better idea.  It'd not be
> hard to implement, and it'd be much safer to use since failures wouldn't
> leave you with bogus catalog contents.

I believe oracle and mssql have ALTER TABLE/DISABLE TRIGGER style 
statements...

Chris



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Transaction aborts on syntax error.
Next
From: Joe Conway
Date:
Subject: Re: pg_restore problems and suggested resolution