Problem between inheritance and references - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject Problem between inheritance and references
Date
Msg-id 20020723102703.GA26435@nic.fr
Whole thread Raw
Responses Re: Problem between inheritance and references
List 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)



Attachment

pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: just a quick one ...
Next
From: Elielson Fontanezi
Date:
Subject: RES: RES: Shell Script help for backup