On Mon, 26 Dec 2016, Tom Lane wrote:
ERROR: there is no unique constraint matching given keys for referenced
table "weather_params".
because Weather_Params.param isn't constrained to be unique.
...
Seeing that Weather_Data also has a site_id column, I'm going to guess
that what you wanted
From: Rich Shepard
My schema includes three tables and psql throws an error I'm not seeing
when I try to read the schema into the database. I'd appreciate fresh eyes
looking at the table and learning what error I'm not seeing.
The tables:
CREATE TABLE Weather (
site_id INTEGER PRIMAR
Rich Shepard writes:
>My schema includes three tables and psql throws an error I'm not seeing
> when I try to read the schema into the database. I'd appreciate fresh eyes
> looking at the table and learning what error I'm not seeing.
Hm, seems straightforward enough to me: the only uniqueness
