If it works with ACS Classic it will work with OpenACS as long as they've implemented the database driver API correctly so that ns_pg statements work.