If PostgreSQL failed to compile on your computer or you found a bug
that
is likely to be specific to one platform then please fill out this form
and e-mail it to pgsql-ports (AT) postgresql (DOT) org.

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs (AT) postgresql (DOT) org.

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches (AT) postgresql (DOT) org instead. Please use the
command "diff -c" to generate the patch.

You may also enter a bug report at http://www.postgresql.org/ instead
of
e-mail-ing this form.

================================================== ==========================
POSTGRESQL BUG REPORT TEMPLATE
================================================== ==========================


Your name : Riccardo Facchini
Your email address : abief_ag_-postgresql@ yahoo.com


System Configuration
---------------------
Architecture (example: Intel Pentium) : i686

Operating System (example: Linux 2.4.18) : Linux 2.4.19-4GB

PostgreSQL version (example: PostgreSQL-8.0): PostgreSQL-7.4.5

Compiler used (example: gcc 2.95.2) : 3.2.2


Please enter a FULL description of your problem:
------------------------------------------------

creating a table that inherits from another two tables with "WITHOUT
OIDS"
generates a table "WITH OIDS", I haven't tested the behaviour with
8.0betaX


Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
CREATE TABLE test1
(
test1_id int4,
test1_value text
);
CREATE TABLE test2
(
test2_id int4,
test2_value text
);
CREATE TABLE test3
(
)
INHERITS (test1, test2)
WITHOUT OIDS;

select relhasoids from pg_catalog.pg_class where relname = 'test3';

relhasoids
------------
t
(1 row)

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------




---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

"Riccardo G. Facchini" <abief_ag_-postgresql (AT) yahoo (DOT) com> writes:
This is not a bug. If either parent table has oids then the child must
as well. It's just like inheriting a regular column.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings