Forum OpenACS Development: Re: OpenACS 5.8(head) on Postgres 9.2
For most purposes in OpenACS oids are not needed. A quick grep returned the following places:
acs-content-repository/sql/postgresql/content-type.sql acs-kernel/sql/postgresql/acs-metadata-create.sql acs-kernel/sql/postgresql/postgresql.sql acs-tcl/tcl/test/datamodel-test-procs.tcl acs-subsite/www/admin/users/new-postgresql.xql acs-subsite/www/pvt/alerts-postgresql.xql
The config flag
default_with_oids is just used for creation of new tables. So if one migrates an existing database to e.g. PG 9*, the oids are as well migrated, and one does not need the flag in the config file.
I am not sure that pg wants to get rid of OIDs, since these are used as PKs for various system tables (see datatype-oid).
For new installations, if the goal is to remove the config dependency, the simplest fix is probably to add
WITH OIDS to the few tables, that still require OIDs.