do you have the following patch in your production site?
http://cvs.openacs.org/cvs/openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql?r1=1.40.2.3&r2=1.40.2.4
http://cvs.openacs.org/cvs/openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql?r1=1.40.2.3&r2=1.40.2.4