A new update is available for Fedora Core - Fedora Core 4 Update: postgresql-8.0.6-1.FC4.1. Here the announcement:

Fedora Update Notification
FEDORA-2005-021
2006-01-10
---------------------------------------------------------------------

Product : Fedora Core 4
Name : postgresql
Version : 8.0.6
Release : 1.FC4.1
Summary : PostgreSQL client programs and libraries.
Description :
PostgreSQL is an advanced Object-Relational database management system
(DBMS) that supports almost all SQL constructs (including
transactions, subselects and user-defined types and functions).

---------------------------------------------------------------------
Update Information:

8.0.6 fixes some critical upstream bugs.
---------------------------------------------------------------------
* Mon Jan 9 2006 Tom Lane <tgl@redhat.com> 8.0.6-1.FC4.1
- Update to PostgreSQL 8.0.6


---------------------------------------------------------------------
This update can be downloaded from:
http://download.fedora.redhat.com/pub/fedora/linux/core/updates/4/

e222b71548062ba9113cb3d4d5855c49c1b5481a SRPMS/postgresql-8.0.6-1.FC4.1.src.rpm
ef457a80a8cb6cd965f42852ab429a4b0a4309a7 ppc/postgresql-8.0.6-1.FC4.1.ppc.rpm
02d7726d48a5d9321542c138fd0b3b94e7d6d287
ppc/postgresql-libs-8.0.6-1.FC4.1.ppc.rpm
44b9a4faa1f17b430339f935614563f9090cec26
ppc/postgresql-server-8.0.6-1.FC4.1.ppc.rpm
dd39f22c061c68640ec12de6d720e10fe483d721
ppc/postgresql-docs-8.0.6-1.FC4.1.ppc.rpm
4f3865fb524f2d81df21251ad7887573e3a1dbb7
ppc/postgresql-contrib-8.0.6-1.FC4.1.ppc.rpm
3582db1c263f8607c1d190519731c6f5d7775687
ppc/postgresql-devel-8.0.6-1.FC4.1.ppc.rpm
9e22ecf2635a046fb8571f1992869f16d0b25bab
ppc/postgresql-pl-8.0.6-1.FC4.1.ppc.rpm
0e8f02731b4ab366bda972707e41b52e5a7fb0ec
ppc/postgresql-tcl-8.0.6-1.FC4.1.ppc.rpm
906894cae53008b2d28d98c3be1d4ed1f10a4de3
ppc/postgresql-python-8.0.6-1.FC4.1.ppc.rpm
9fab15942a8c73f1d8a862354944407a46b8314f
ppc/postgresql-jdbc-8.0.6-1.FC4.1.ppc.rpm
9ae14625392fa88b675a3275949796e64f9cf138
ppc/postgresql-test-8.0.6-1.FC4.1.ppc.rpm
45187221438cb2daf05fb81a48103124e27a9158
ppc/debug/postgresql-debuginfo-8.0.6-1.FC4.1.ppc.rpm
f24093a7f50dccf65a3ea8f1e9b64eac59afbc2b
x86_64/postgresql-8.0.6-1.FC4.1.x86_64.rpm
08b6b87dd6a1b47957e182d92b852b97315747db
x86_64/postgresql-libs-8.0.6-1.FC4.1.x86_64.rpm
0002278d4df7443e303ebfed793281f766d5b62e
x86_64/postgresql-server-8.0.6-1.FC4.1.x86_64.rpm
337ae072272c114ef6aa61dbfeee505a6764bb97
x86_64/postgresql-docs-8.0.6-1.FC4.1.x86_64.rpm
e884434cbb3a79ae31b76e55f2a0b0531c8f15fa
x86_64/postgresql-contrib-8.0.6-1.FC4.1.x86_64.rpm
7ddb85d918a381571061cf543d0d9dd0ca2971b7
x86_64/postgresql-devel-8.0.6-1.FC4.1.x86_64.rpm
2b5c77569c5d150acae8818c4849b7b12cebebc3
x86_64/postgresql-pl-8.0.6-1.FC4.1.x86_64.rpm
3198a214bd69fc6870e102ef4be67fccf58745be
x86_64/postgresql-tcl-8.0.6-1.FC4.1.x86_64.rpm
3db06f65830ad7196b699554942bf9568c624e49
x86_64/postgresql-python-8.0.6-1.FC4.1.x86_64.rpm
46dc3fef91cb22e16840df84d3499301b4b9888c
x86_64/postgresql-jdbc-8.0.6-1.FC4.1.x86_64.rpm
40f8d01e4b6033aa3592572a9b5afc22bedc7dfc
x86_64/postgresql-test-8.0.6-1.FC4.1.x86_64.rpm
0249b1615a3a243f28b124bdb45bcaa7532069f6
x86_64/debug/postgresql-debuginfo-8.0.6-1.FC4.1.x86_64.rpm
c98463dcdb8d41ecc9335c7218619e7fea88cbe5 i386/postgresql-8.0.6-1.FC4.1.i386.rpm
ff8524e3343378de58a90b6acb1465ebfcf65319
i386/postgresql-libs-8.0.6-1.FC4.1.i386.rpm
29346f52bc8bbb5672848086da74ba2d26f9fae9
i386/postgresql-server-8.0.6-1.FC4.1.i386.rpm
ef708bc8547adcbb559f97093e6dfe96f9b77079
i386/postgresql-docs-8.0.6-1.FC4.1.i386.rpm
9352010bccf9f94b5d789bdd9a032646765835af
i386/postgresql-contrib-8.0.6-1.FC4.1.i386.rpm
d7466a7ffc2588bd7f38e9285fe41fc153a4cf4b
i386/postgresql-devel-8.0.6-1.FC4.1.i386.rpm
146ad187c504fcd3e06104fdfd16c30a6a76e02d
i386/postgresql-pl-8.0.6-1.FC4.1.i386.rpm
3bb2130072fc6810b6b9f6be879d12909d2021a9
i386/postgresql-tcl-8.0.6-1.FC4.1.i386.rpm
680a32ed65169a96851b2875c6ae8ddd8d09039d
i386/postgresql-python-8.0.6-1.FC4.1.i386.rpm
781db74da1ac2b299ffcfebe2d016d72fc3af37b
i386/postgresql-jdbc-8.0.6-1.FC4.1.i386.rpm
6874d60ff412ece11b93eefbf0cc9d79b1be8f16
i386/postgresql-test-8.0.6-1.FC4.1.i386.rpm
db36b138fc5052f1df8790e40547e4c68dc81431
i386/debug/postgresql-debuginfo-8.0.6-1.FC4.1.i386.rpm

This update can also be installed with the Update Agent; you can
launch the Update Agent with the 'up2date' command.