Claire McLister <mclister@xxxxxxxxxxxxx> 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
