postgresql7.4 SELECT name FROM lrc_template WHERE template_id = :template_id UPDATE lrc_resource SET name = :name, url = :url, description = :description WHERE resource_id = :resource_id UPDATE acs_objects SET modifying_user = :modifying_user, modifying_ip = :modifying_ip, package_id = :package_id WHERE object_id = :resource_id