Problem between inheritance and references

Поиск
Список
Период
Сортировка
От Stephane Bortzmeyer
Тема Problem between inheritance and references
Дата
Msg-id 20020723102703.GA26435@nic.fr
обсуждение исходный текст
Ответы Re: Problem between inheritance and references  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
I'm just beginning with inheritance and I have problems using
REFERENCES integrity constraints to an inherited table. The schema is
attached. When I try the second INSERT, I get:

psql:./auth.sql:22: ERROR:  <unnamed> referential integrity violation - key referenced from users not found in
authentication

But the key does exist:

auth=# select * from Authentication;
 id
----
  1
(1 row)

auth=# select * from Passwords;
 id |  password
----+------------
  1 | trustnoone
(1 row)



Вложения

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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: just a quick one ...
Следующее
От: Elielson Fontanezi
Дата:
Сообщение: RES: RES: Shell Script help for backup