On Thu, Mar 18, 2010 at 8:31 PM, D. Richard Hipp <d...@hwaci.com> wrote:
> The "22" is a semi-transient rowid on an internal table (semi-
> transient in the sense that it is different on each repository and
> probably changes when you "rebuild"). Allowing rowids in this context
> is bad design, it seems to me. This is something I am working to fix.
>
In my experience, sqlite rowids are not transient IFF you explicitly declre
them in the CREATE TABLE code. e.g. here's a snipped i've got lying around:
CREATE TABLE c11n_SQLITE_TBL_N -- c11n_nodes
(
rowid INTEGER PRIMARY KEY AUTOINCREMENT,
pid INTEGER REFERENCES c11n_SQLITE_TBL_N(rowid),
class TEXT,
name TEXT
);
:-?
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
