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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to