Hi,

Recently I've found one problem in SQLite and I think that this is a bug.

Are there any ways to use rowid column in one table as a foreign key in another?
By the rowid I mean internal column that used as an alias for INTEGER
PRIMARY KEY columns.

As described at documents, SQLite supports foreign keys as of version 3.6.19.
When I use a new version of SQLite it doesn't do anything to save a
referential integrity.
I also tried to use utility .genfkey in older version to create
TRIGGERS for my database but it says that there is no such column in
parent table or something like this.

Do anyone encounter this problem or I just did something wrong?

-- 
WBR,
inst
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to