Displaying 1 result from an estimated 1 matches for "fk_topic_subtopic_subtopic_1".
2006 Mar 29
0
active record bug?
...pic Load (0.000649) SELECT * FROM topics WHERE (topics.id = 3126)
LIMIT 1
# and print out a logger statement showing that the topic exists:
topic exists
TopicSubtopic Create (0.000000) PGError: ERROR: insert or update on
table "topic_subtopic" violates foreign key constraint
"fk_topic_subtopic_subtopic_1"
DETAIL: Key (child_topic_key)=(3126) is not present in table "topics".
: INSERT INTO topic_subtopic ("child_topic_key", "topic_key",
"display_header") VALUES(3126, 2, ''Medications'')
The constraint on topic_subtopic is:
ALTER TABLE ON...