On 18 Nov 2013, at 2:24 pm, Chris Travers <chris.travers@gmail.com> wrote:
>
> I haven't done work with this so I am not 100% sure but it seems to me based on other uses I have for table
inheritancethat it might work well for enforcing interfaces for natural joins. The one caveat I can imagine is that
thereare two issues that occur to me there.
>
> 1. If you have two child tables which add a column of the same name, then your centralized enforcement gets messed
upand you have a magic join which could take a while to debug....
>
> 2. The same goes if you have two child tables which also inherit a different parent table for a different natural
join....
>
> To be honest I think being explicit about joins is usually a very good thing.
I can see how debugging a magic join would quickly outweigh any benefits and the “USING()” clause nicely reflects the
foreignkey definition, so I’ll stick with explicit joins.
Thanks,
Tony