I have a feature request for our dear fellow developpers : I would like to be able to create a foreign key constraint that references a view (or anything that looks like a table, as a function returning a table for instance) instead of a table.
Does that look doable ? The trickiest part is probably to ensure the constraint when the tables the view is built on are modified...