From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Darrin Domoney <ddomoney(at)emergingfrontiers(dot)ca> |
Cc: | <pgsql-sql(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: [SQL] Urgent - SQL Unique constraint error (long) |
Date: | 2002-08-19 17:41:21 |
Message-ID: | 20020819103903.D32160-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-novice pgsql-sql |
On Mon, 19 Aug 2002, Darrin Domoney wrote:
> An admitted newbie to postgresql I am trying to commit a new design
> my development server using pgAdminII.
>
> Everything appears to work OK but I am having real grief with my
> SQL generating errors - most of which I have cleared myself but
> one that I am unsure how to handle:
>
> UNIQUE constraint for matching given keys for referenced table "staff"
> not found
>
> Below is the SQL code that I am tring to load to build out my database
> skeleton:
>
> CREATE TABLE staff
> (
> staff_id serial NOT NULL,
> person_id int NOT NULL,
> active_staff boolean NOT NULL,
> pay_rate decimal(8,2),
> discounted_rate decimal(8,2),
> discount_break int,
> organization_id int NOT NULL,
> PRIMARY KEY (staff_id)
> );
> ALTER TABLE phone_number ADD CONSTRAINT staff_phone
> FOREIGN KEY ( person_id )
> REFERENCES staff ( person_id )
> NOT DEFERRABLE;
The target of a references constraint must be in a unique
constraint. Here you're referencing person_id which
is not the key of staff. Are you sure you don't want
to be linking staff_id instead?
From | Date | Subject | |
---|---|---|---|
Next Message | paul butler | 2002-08-19 18:10:50 | Re: Urgent - SQL Unique constraint error (long) |
Previous Message | Darrin Domoney | 2002-08-19 17:34:53 | Urgent - SQL Unique constraint error (long) |
From | Date | Subject | |
---|---|---|---|
Next Message | paul butler | 2002-08-19 18:10:50 | Re: Urgent - SQL Unique constraint error (long) |
Previous Message | Darrin Domoney | 2002-08-19 17:34:53 | Urgent - SQL Unique constraint error (long) |
From | Date | Subject | |
---|---|---|---|
Next Message | paul butler | 2002-08-19 18:10:50 | Re: Urgent - SQL Unique constraint error (long) |
Previous Message | Darrin Domoney | 2002-08-19 17:34:53 | Urgent - SQL Unique constraint error (long) |