Nice post. This reminds me of the ESRI Enterprise Geodatabase system.
You can build one into a PostgreSQL database, but you can't edit data with non-ESRI tools because it handles IDs and relations in its own way. It's built like that because the same structure is used in their other GeoDatabase formats, but it has the convenient side-effect of locking the data into their tools.