Re: [GENERAL] ALTER TABLE ... DISABLE TRIGGERS Isolation leve

2011-05-09 Thread Tom Lane
CG writes: > I want to add a column to a table, but there are update triggers that will > fire that don't need to fire for this operation. So, I'd like to add the > column with triggers off. Normally this operation would take 10 or so > seconds, so locking the table for that amount of time is n

[GENERAL] ALTER TABLE ... DISABLE TRIGGERS Isolation leve

2011-05-09 Thread CG
I'm using 8.4.1 I want to add a column to a table, but there are update triggers that will fire that don't need to fire for this operation. So, I'd like to add the column with triggers off. Normally this operation would take 10 or so seconds, so locking the table for that amount of time is not