Forum OpenACS Q&A: Response to dml and other sql errors
In my experience, the best is to start from scratch and making sure you have these steps:
Make sure you compiled the enhanced PostgreSQL driver available here at the acspg site. Without that, nothing will work.
Make sure you have the right permissions and that the datamodel is being loaded by the user that AOLserver will be connecting to PostgreSQL as.
Follow the steps I described in http://acspg.benadida.com/bboard/q-and-a-fetch-msg.tcl?msg_id=00000x&topic_id=5&topic=ACS%2fpg%20Installation%20and%20Configuration>.
Since you are using the RPM version of PostgreSQL, make sure you are RTFM, and you are uncommenting (and commenting) the right lines in postgres.sql (that includes uncommenting postgres65.sql)