Re: [GENERAL] FOREIGN KEY CONSTRAINT AND INHERITANCE

2007-04-25 Thread A. Kretschmer
am Wed, dem 25.04.2007, um 19:25:46 +0400 mailte Sergey Karin folgendes: > vka7=# insert into style_type_object values(1, 2, false, 0, 0); > ERROR: insert or update on table "style_type_object" violates foreign key > constraint "fk_id_style" > DETAIL: Key (id_style)=(2) is not present in table "

[GENERAL] FOREIGN KEY CONSTRAINT AND INHERITANCE

2007-04-25 Thread Sergey Karin
Hi, All! I have the tables as defined: create table style ( ID_STYLE INT4 not null, STYLE_STRING VARCHAR not null, constraint PK_STYLE primary key (ID_STYLE) ); create table style_type_object ( ID_TYPE_OBJECT INT4 not null, ID_STY