> Any suggestions would be more then appreciate as always. Is there a > better way to do what I'm trying to do? I would recommend using only one sequence for the master table. Then just reference that sequence value for the two foreign keys. For example: BEGIN; INSERT INTO Bugs (bug_date) VALUES (CURRENT_DATE); INSERT INTO BugA (bug_id,bug_desc) VALUES (currval('bugs_bug_id_seq'),'This is a bug'); INSERT INTO BugB (bug_id,bug_fix) VALUES (currval('bugs_bug_id'),'Reinstall Windows... again'); COMMIT; This way, you don't have to worry about sequences getting out of sync because they all refer to the same value. As for the timestamp problem... I don't know how you are trying to INSERT those values (interface, SQL, etc). Greg ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster