Thought I understood this, but evidently not...
couldn't find anything in the docs or archives that
helped me, either.
Trying to add a new table, then referencing a number
of other tables to a field in the new table. Table
definition:
create table "employee" (
"emp_id" integer default
nextval('employee_emp_id_key'::text) not null,
"emp_num" text,
"first_name" text not null,
"middle_name" text,
"last_name" text not null,
"suffix" text,
"salutation" text,
"ssn" text,
"sex" text,
"race_id" text,
"dob" date,
"review" text,
"comment" text,
"history" text,
"date_entered" date,
"marital_status" text,
"ond3" boolean,
constraint "employee_pkey" primary key
("emp_id"),
constraint "emp_num_key" unique (emp_num)
);
personnel_benefits=# \i employees.dump
You are now connected as new user jeck.
psql:employees.dump:31: NOTICE: CREATE TABLE/PRIMARY
KEY will create implicit index 'employee_pkey' for
table 'employee'
psql:employees.dump:31: NOTICE: CREATE TABLE/UNIQUE
will create implicit index 'emp_num_key' for table
'employee'
CREATE
personnel_benefits=# alter table emp_insurance add
constraint ei_emp_fk foreign key (emp_no) references
employee (emp_no);
NOTICE: ALTER TABLE ... ADD CONSTRAINT will create
implicit trigger(s) for FOREIGN KEY check(s)
ERROR: UNIQUE constraint matching given keys for
referenced table "employee" not found
personnel_benefits=#
__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
