AW: PLEASE help with foreign key and inheritance proble m

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: PLEASE help with foreign key and inheritance proble m
Дата
Msg-id 11C1E6749A55D411A9670001FA68796336817A@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список pgsql-hackers
> I stated this before, but I did not get a helpful answer. I 
> might have 
> misunderstood tghe documentation on foreign keys:
> 
> create table global(id serial);
> create table child(anything text) inherits(global);

need:create unique index child_id_index on child (id);

> gives me an error: 
> CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
> ERROR:  UNIQUE constraint matching given keys for referenced 
> table "child" 
> not found  

Then the above works. 
Actually the error message sounds sufficiently clear to me, no?

Andreas


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Horst Herb
Дата:
Сообщение: PLEASE help with foreign key and inheritance problem
Следующее
От: mlw
Дата:
Сообщение: Re: external function proposal for 7.2