In my DDL I have “integer primary key not null” on my tables. When I do the
first insert to these tables the rowid is assigned. The insert statement is a
“insert or replace into…” so I don’t have to deal with insertion errors.
However, I expected the rowid to not change when the row has not changed (when
the replace is part of the clause is used). Is there a way to not have the
rowid changed when “insert or replace into…” is used?
sqlite-users mailing list