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)