types-create.sql calls content_type__create_type, which conditionally does a "create table" for the new type. It would appear that create is causing the problem.
Now ...
I just did a fresh install of OpenACS 4 on my RH 6.2 box with PG 7.1.2, and didn't run into a problem.
You've gotten it to install without a problem on Windoze.
This makes me thing something's wrong with your PG installation. Is the box a pure development box? Can you reinstall PG, make sure you get rid of all old traces of it, do a "initdb" and fresh "createdb" and fresh reinstall of OpenACS4?
I know that sounds like a lot of work but given that it is installing for other and even for you on your windows box, I'm suspicious that something's screwy on the RH 6.2 box.
Also make sure it is really running your PG 7.1.2. In other words that any old postmaster's been stopped, that the old version's been thoroughly deleted, that you don't have any RH-installed components lying around and in your PATH (RH RPMS install PG in a different place
than the PG distro tarball).
Etc etc etc...
