3.3. Foreign Keys

[..]

CREATE TABLE cities (name		varchar(80) primary key,location	point
);

CREATE TABLE weather (city		varchar(80) references weather,temp_lo		int,temp_hi		int,prcp		real,date		date
);

Table weather refernces table cities and not itself.

Best regards