Dan Herbert <dan@xxxxxxxxxxx> 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 trigger records found for relation "users" then the pg_trigger records must be gone too, which AFAIK Slony doesn't do. Do you have *any* idea what caused this? Also, what PG version are you running exactly? As far as getting out of it is concerned, I'd be inclined to do a "pg_dump -s" from the devel DB, manually extract all the alter-add-constraint commands, and replay them into the live DB, after having gotten rid of any duplicates of constraints that are still there. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
