Just in case no one else has found it, in the tutorial docs on page
file:/usr/share/doc/packages/postgresql/html/tutorial-fk.html says:
>>>
CREATE TABLE weather (
city varchar(80) references weather,
temp_lo int,
temp_hi int,
prcp real,
date date
);
<<<
and talks about the foreign key insert error. But that did not work when I
tried it. I believe the doc should say:
>>>
CREATE TABLE weather (
city varchar(80) references cities,
temp_lo int,
temp_hi int,
prcp real,
date date
);
<<<
The difference is the table referenced, cities not weather. That does allow
the example to work.
HTH,
Kevin Brannen