INHERITS behavor - Mailing list pgsql-general

From Andrey Y. Mosienko
Subject INHERITS behavor
Date
Msg-id 3ABC9258.BAB3B5F8@ttn.ru
Whole thread Raw
Responses Re: INHERITS behavor  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
I am using PGSQL 7.1RC1.

CREATE TABLE "test" (
   "id" int4 DEFAULT nextval('"test_id_seq"'::text) NOT NULL,
   "val" int4,
   CONSTRAINT "test_pkey" PRIMARY KEY ("id")
);

CREATE TABLE test_1 (
) INHERITS (test);

Do:
INSERT INTO "test_1" ("id", "val") VALUES ('2', '2')

The same record appears in test!!!!

Why? When I used 7.0.3 there was no such thing!

How can I get old behavor?

--
with respection Andrey Feofilactovich.
e-mail: feo@ttn.ru, feo@feo.org.ru
ICQ: 28073807

pgsql-general by date:

Previous
From: Stephen Davies
Date:
Subject: Re: Null records inserted
Next
From: Richard Huxton
Date:
Subject: Re: from string to table...?