Re: [GENERAL] INHERITS behavor

2001-03-24 Thread Peter Eisentraut
Andrey Y. Mosienko writes: > 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",

[GENERAL] INHERITS behavor

2001-03-24 Thread Andrey Y. Mosienko
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" (