"Zhang, Anna" <[EMAIL PROTECTED]> writes: > ERROR: RelationBuildTriggers: 2 record(s) not found for rel domain.
> I deleted triggers that referenced domain before vacuum, is this the cause? If you deleted them via "delete from pg_trigger" and not by DROP TRIGGER, then yes. You'll need to manually fix the value of pg_class.reltriggers for that table. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])