I've changed "timestamp" to "timestamptz" and have begun fixing some code that used to be legal but as of PG 7.3 is not. You can no longer subtract an integer from a timestamp but must cast to date, "timestamp" disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"), and suchwhat.
Added 'on delete cascade' constraint to bt_projects_apm_packages_fk, and sourcing bug-tracker-notifications-init.sql, so notifications actually work when you install bug-tracker :)