because I am stupid I forgot the solution to this is drop trigger "RI_ConstraintTrigger_44349" on users; (with the quotes); you get the number from the comments in the dump file. I found out the hard way today what manually deleting rows from pg_trigger does. :(
