"The parent key of a foreign key constraint is not allowed to use the
rowid. The parent key must used named columns only."
Why is this?
Which would be more efficient?
1) WITHOUT ROWID and column of INTEGER PRIMARY KEY
or
2) an aliased rowid.
Background: The data is sparse, incomplete, and fuzzy. Two records are
known to have a relationship
even though the content that identifies this relation is not known.
Lyle Ward
Genealogist
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users