As of postgresql-7.4.1-r2.ebuild the pgsql includes have beenmoved again; this time from /usr/include/postgresql/pgsql tojust /usr/include/postgresql.
So if you are at 7.4.1-r2 link to postgresql/* rather thanto postgresql/pgsql/*.
-JimC