> 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
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
Good morning,
Hoping someone is able to help me here...
Had a strange issue in a production db this morning: records existed
in one table with a foreign key value which didn't exist in another
table.
TL;DR - many triggers for constraints (and more?) are gone; can they
be recreated easily?
For r
