Wow. Thanks. I see now that this is mentioned in the docs on the page for the VACUUM statement. It really should be mentioned on the CREATE TABLE page also where the rowid is explained. This is important information for people who are learning SQLite and trying to figure out how to design their database!
Jay A. Kreibich-2 wrote: > > On Wed, Nov 17, 2010 at 04:36:12PM -0600, Bernard Ertl scratched on the > wall: > >> Is it not possible to reference the SQLite >> internal/default column for the RowID in a foreign key definition? > > Even if you could, you don't want to do this. > > Unless you define an ROWID alias (i.e. an INTEGER PRIMARY KEY column) > ROWID values are not preserved across vacuums or dumps. > > -j > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Intelligence is like underwear: it is important that you have it, > but showing it to the wrong people has the tendency to make them > feel uncomfortable." -- Angela Johnson > _______________________________________________ > sqlite-users mailing list > email@example.com > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Using-foreign-key-reference-on-RowID-tp30246958p30248863.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users