I haven't worked with PostgreSQL much at all yet, but doesn't there need to
be a primary key constraint on the emp_address_tb's emp_id column in order
to set up the foreign key relation between the two emp_id columns?
Sort of, there has to be a unique index (which a pk by design is).
in a future version (1.3/1.4) we might have some autodetect mechanism for those columns.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
