Najm,
> references age_list(id);
> And I get the following error:
> flipr=# alter table users
> flipr-# add constraint age_fk foreign key(age) references
> age_list(id);
> NOTICE: ALTER TABLE ... ADD CONSTRAINT will create
> implicit trigger(s)
> for FOREIGN KEY check(s)
> ERROR: <unnamed> referential integrity violation - key
> referenced from
> users not found in age_list
Simple ... you have values in the AGE column that are not in
the age_list table. Thus you're in violation of the foriegn
key you're trying to establish.
-Josh Berkus