Hi Jack,
In the oracle version of the CR, c_root_folder is a package constant.
Since PG doesn't have 'packages', it's been recoded as a view -
content_item_globals.c_root_folder_id (see the top of the file
acs-content-repository/sql/postgresql/content-item.sql)
so you should do:
PERFORM
content_folder__unregister_content_type(content_item_globals.c_root_folder_id
...);