bugreport 7.4.5

Started by Riccardo G. Facchiniover 21 years ago2 messagesbugs
Jump to latest
#1Riccardo G. Facchini
abief_ag_-postgresql@yahoo.com

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@postgresql.org.

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

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches@postgresql.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:
---------------------------------------------------------------------

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Riccardo G. Facchini (#1)
Re: bugreport 7.4.5

"Riccardo G. Facchini" <abief_ag_-postgresql@yahoo.com> writes:

creating a table that inherits from another two tables with "WITHOUT
OIDS" generates a table "WITH OIDS",

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