Please note that the security issues were those already reported by Tom Lane, as well as a manual fix for them. These releases are mainly to ensure that those installing and/or upgrading existing installations have those fixes automatically.
Note that if you're upgrading within a release series (e.g. 8.0.x to 8.0.3) without a dump and reload, you will _not_ get the necessary system catalog changes automatically. Tom's earlier mail describes the procedure needed to correct the system catalog:
http://www.postgresql.org/about/news.315
-Neil
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster