Re: [GENERAL] Recreating constraint triggers

2010-09-02 Thread Dan Herbert
> Ouch.  Are you running Slony by any chance? Nope, just a stock install. Both servers are running CentOS. > Do you have *any* idea what caused this? Nothing definitive unfortunately. Looking back through SVN logs for code updates there was mention of disabling triggers to perform a large delete

Re: [GENERAL] Recreating constraint triggers

2010-09-02 Thread Tom Lane
Dan Herbert writes: > select reltriggers from pg_class where relname='users'; >> Development db: 80 >> Live db: 2 Ouch. Are you running Slony by any chance? It's known to fool around with reltriggers and sometimes mess it up. However, if you're not getting constant bleats like too many