On Mon, 20 Jul 2009, Simon Slavin wrote:

> Rather than move genfkey, it would make more sense to implement foreign
> key constraints, since that's what it pretends to implement. However, I
> don't know enough about how SQLite works internally to know how difficult
> this would be.

Simon,

   I use triggers to enforce referential integrity with foreign keys. Is this
not a suitable approach for what you want to do?

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to