Hello, While copying from a text file of tab delimited data I am getting " ERROR: <unnamed> referential integrity violation - key referenced from films not found in sales" The salesid field salesid INTEGER PRIMARY KEY DEFAULT NEXTVAL('sales_serial') exists Help =:-D Cheers Tony Grant ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html