Forum OpenACS Development: Re: Audit of postgres plpgsql procs...

Collapse
5: Re: Audit of postgres plpgsql procs... (response to 4)
Posted by Jeff Davis on 11/21/03 11:45 PM
I think these should be changed to stable: 
 trigger_type
 acs_objects_get_tree_sortkey
 forums_message__root_message_id
 file_storage__get_root_folder
 file_storage__get_package_id
I don't see any others that should be a problem.

Strictly speaking acs__magic_object_id maybe should be but I think it's safe to leave as immutable...

Collapse
6: Re: Audit of postgres plpgsql procs... (response to 5)
Posted by Jeff Davis on 11/24/03 07:29 PM
I committed the changes for the core plpgsql procs and provided an upgrade script for the procs which changed internally (bug fixes), but no upgrade script to change the strict/volatile flags. I will try to get one together in the next day or two.