Claire McLister <mclister@zeesource.net> writes:
> Thanks for your quick response. Sorry for the omission, the PG
> version is 7.4.8
> How do I temporarily disable the trigger while doing the restore?
> Should I remove the trigger, do the dump, and then work from there?
Yeah, it looks like that's the easiest answer in 7.4 :-(. I had thought
that pg_restore's --disable-triggers might help you, but it looks like
it won't fire unless you use a data-only restore, which is generally not
a preferable way to do things.
regards, tom lane