> On Thu, Dec 22, 2016 at 11:50 PM, Günce Kaya
> wrote:
>
>> Hi All,
>>
>> I'm looking for an ER Data Modeller tool for postgresql. I use Navicat
>> Premium for postgresql and the tool has a modeller but I would like to
>> display a database modeller that belonging to a tables of an schema under a
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 PRIMARY KEY,
site_name TEXT,
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
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
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
