Forum OpenACS Q&A: Response to Any problems found with Postgres 7.2?

Actually, the APM is broken in 7.1 as well. Don fixed a race condition in acs-tcl/tcl/security-procs.tcl yesterday, but changed clob_dml to clob_insert_dml in one spot. Changing that back to clob_dml fixes part of the problem, but then a query is missing (prop_update_dml). Adding this to acs-tcl/tcl/security-procs.xql seems to fix that problem as well:

<fullquery name="ad_set_client_property.prop_update_dml">
      <querytext>

                update sec_session_properties
                set     property_value = :value,
                        last_hit = :last_hit,
                        secure_p = :secure
                where  session_id = :session_id
                and    module = :module
                and    property_name = :name

      </querytext>
</fullquery>

I haven't made these changes in CVS in case I interpreted something wrong.