"Mark Borins" <mark.borins@xxxxxxxxxxx> writes: > Does anyone know if it is possible to run an update statement on a table and > for only that statement disable the trigger on the table? No, but why fire the update if not needed? Make the trigger do something like UPDATE foo SET boolcol = true WHERE ... AND not boolcol; regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org