Fwd: Re: HELP! foreign eys & inheritance

Поиск
Список
Период
Сортировка
От Horst Herb
Тема Fwd: Re: HELP! foreign eys & inheritance
Дата
Msg-id 00121301254004.03185@munin.midgard
обсуждение исходный текст
Ответы Re: Fwd: Re: HELP! foreign eys & inheritance  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-hackers
Ooops, sorry, error in this example:
> The following example worked in previous versions (7.0.2 was the last I
> tested), but not in 7.1 any more:
>
> create table parent (
> global_id serial
> );
>
> create table child (
> anything text
> ) inherits (parent);
>
> create table foreign (
> fk_id int4 references child(global_id) on update cascade on delete no

action                                 ^^^^^ child, of course, not parent!

> ) inherits (parent);
>
> test.sql:83: ERROR:  UNIQUE constraint matching given keys for referenced
> table "child" not found
> WHY ???
>
> I would appreciate any help. Our database depends heavily on this.
>
> Horst

-------------------------------------------------------


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: COPY BINARY file format proposal
Следующее
От: Barry Jenner
Дата:
Сообщение: Re:Postgresql on dynix/ptx system