On 9/6/23 00:14, David G. Johnston wrote:
I'm not all that for either A or B since the status quo seems workable.
Pray tell, how is it workable? The view does not identify a specific constraint because we don't obey the rules on one side and we do obey the rules on the other side. It is completely useless and unworkable.
Though ideally if the system has unique names per schema then everything should just work - having the views produce duplicated information (as opposed to nothing) if they are used when the DBA doesn't enforce the standard's requirements seems plausible.
Let us not engage in victim blaming. Postgres is the problem here. -- Vik Fearing
