On Saturday, April 25, 2015, Tom Lane <t...@sss.pgh.pa.us> wrote:

>
> It's perhaps debatable whether it should act that way, but in the absence
> of complaints from the field, I'm hesitant to change these cases.  It
> might be better if the effective behavior were "table gets OIDs if
> default_with_oids = true or WITH OIDS is given or base table has OIDs".


+1


>
> Still another case that needs to be thought about is "create table likeit
> (like base) without oids" where base does have OIDs.  Probably the right
> thing here is to let the WITHOUT OIDS spec override what we see in base.
>
>
Why are oids special in this manner?  No other inherited column can be
omitted from the child table.  Though I guess unlike inherits there is no
reason to mandate the final result be identical to the base table - though
here is something to be said for pointing out the inconsistency and
requiring the user to alter table if indeed they want to have the oid-ness
changed.

David J.

Reply via email to