Forum OpenACS Q&A: Response to ad_maintain_last_visits error after renaming table...

If you don't have a dump from before you renamed the table, you've exceeded my experience.  I would try renaming the table back to see if that unconfuses pg_dump.  After you have the dump you can drop the trigger(s) manually as I described.