Rod Taylor <rbt@rbt.ca> writes:
> Quick patch to add the subject. Restructures all inheritance to consist
> of a few flags to indicate which structures we want to inherit
I think overloading the inheritance mechanism to serve this purpose is a
bad idea. It complicates and confuses a significant amount of code
that's already pretty confusing (no, I don't believe you found it all).
It'd be better to have a localized bit of code that processes LIKE by
generating a ColumnDef schema list.
> Yes, I wish to add an option to allow check
> constraints to be carried over despite the below note from Sect. 11.3:
> NOTE 234 <column constraint>s, except for NOT NULL, are not included
> in NCi; <column constraint definition>s are effectively transformed to
> <table constraint definition>s and are thereby also excluded.
Why is it a good idea to ignore the express requirement of the spec?
(I'm not saying it's not a good idea --- that note seems a little odd
to me too --- but presumably the spec writers had some reasons for
doing it that way. I'd like some justification for not doing it their
way.)
regards, tom lane