I am looking for ways to ensure referential integrity on large objects. Something like having a column myoid in a table that holds an oid of a large object, and which throws an error when the referenced large object should be unlinked. Like "myoid references pg_largeobject(loid)", which does not work right now, as foreign keys to catalogs are not supported.
Do you have any idea if this could be accomplished? Would it be complicated? Could it be realised as a sponsored development? If so, what would be the estimated effort/cost?
I'd be happy to get any hints at this.