Re: Triggers and COPY

Ericson Smith wrote:

> Hi,
> 
> Is there any way to prevent a trigger from firing during a COPY operation?
> 
> We have a case where we dump the records from a table, truncate it, and 
> copy the records back in. However, there is a trigger on that table, 
> which will insert a record in a logging table. Is there a way to prevent 
> this trigger from firing during the COPY FROM process?

Can you drop the trigger during copy? I don't know following will exactly work 
but something like..

begin
drop trigger
copy
recreate trigger
commit;

could do trick for you..

HTH

  Shridhar