-- Populate the newly created object_id column with the group_ids from -- message keys that have been automatically generated -- (untested) update lang_message_keys set object_id = cast(split_part(message_key, '_', 3) as integer) where package_key = 'acs-translations' and message_key like 'group_title_%' and exists (select 1 from acs_objects where object_id = cast(split_part(message_key, '_', 3) as integer));