the other option would require performing a recursive query, across multiple tables and multiple postgres databases (in the same instance) to find the top of the hierarchy tree