Claire McLister <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
