Error when loading data

[songwu0001]

Hi there,

I created the stackoverflow_dba database using schema.sql, then the foreign key error was reported when loading the data.

ERROR: Key (postid)=(22) is not present in table "posts".insert or update on table "votes" violates foreign key constraint "votes_postid_fkey"

ERROR: insert or update on table "votes" violates foreign key constraint "votes_postid_fkey"
SQL state: 23503
Detail: Key (postid)=(22) is not present in table "posts".

So should I use schema_nofk.sql instead?

Thanks very much!

[toschmidt]

For benchmarking especially analytical systems, I would drop the foreign keys so use schema_nofk.sql.

If I remember correctly the dataset fullfills every foreignkey constraint except the votes-post-fk, so you could also remove this one. We included it in the schema, so that LLMs know to join these two keys.