Deds, what FC1 removes is the PostgreSQL 7.2 compatibility libraries package. PostgreSQL itself is still included.
I typically package the 'Official' RPMset with whatever it is I am running. That is currently Fedora Core 1 (aka Yarrow).
Speaking of, the 7.4 release candidate set has been significantly delayed, but I hope to get it done this week or next.