Обсуждение: Missing error condition in CREATE TABLE

Hi,

Shouldn't this be a WARNING or an ERROR?  Trying to create a table 
WITHOUT OIDS that inherits from a table WITH OIDS silently ignores the 
WITHOUT OIDS specification.  It think that should be a warning...

test=# create table a (a int4);
CREATE TABLE
test=# create table c () inherits (a) without oids;
CREATE TABLE
test=# select relhasoids from pg_class where relname='c'; relhasoids
------------ t
(1 row)


Chris

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Shouldn't this be a WARNING or an ERROR?  Trying to create a table 
> WITHOUT OIDS that inherits from a table WITH OIDS silently ignores the 
> WITHOUT OIDS specification.  It think that should be a warning...

I'm not convinced.  You might as well claim it's wrong that the child
inherits other parent columns that you didn't specify in its CREATE
command.  IOW, for user columns a column will appear in the child if
it's defined by the parent or by the child --- seems to me that OID
should work the same.
        regards, tom lane