Hi I am new to SQL. Is there a way to lock or disable temporarily a trigger? Since under load conditions while updating the database if the triggers are down then it might help updating the db faster. I am using postgre 7.2 and have to update only with INSERT commands. since with copy command i cannot update columns of my choice, meaning all the columns of a table has to be loaded with a copy command. Can any one help me with this and clarify. These triggers are RI_ConstraintTriggers. Regards sid __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org