Thread: bugreport 7.4.5

bugreport 7.4.5

From
"Riccardo G. Facchini"
Date:
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:
---------------------------------------------------------------------

Re: bugreport 7.4.5

From
Tom Lane
Date:
"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