UNIQUE constraint matching given keys for referenced table "employee" not found

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