There was just that question posed earlier today. I'll refer you to the archives, where Terry Lee Tucker weighed in with a good response: <http://archives.postgresql.org/pgsql-general/2005-01/msg01284.php> I hope that helps, Jeff Davis On Mon, 2005-01-24 at 22:48 -0800, sid tow wrote: > 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
