The UNIQUE will either do nothing, or will erase existing lines if a trigger is forgotten. So not having the UNIQUE seems safer. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
- [sqlite] Enforcing uniqueness from multiple indexes Wout Mertens
- Re: [sqlite] Enforcing uniqueness from multiple indexes Richard Hipp
- Re: [sqlite] Enforcing uniqueness from multiple ind... Wout Mertens
- Re: [sqlite] Enforcing uniqueness from multiple ind... Gerry Snyder
- Re: [sqlite] Enforcing uniqueness from multiple... Richard Hipp
- [sqlite] Enforcing uniqueness from multipl... wout.mertens
- Re: [sqlite] Enforcing uniqueness from multiple ind... R Smith
- Re: [sqlite] Enforcing uniqueness from multiple... R Smith
- Re: [sqlite] Enforcing uniqueness from mult... David Raymond
- Re: [sqlite] Enforcing uniqueness from... Wout Mertens
- Re: [sqlite] Enforcing uniqueness ... Nico Williams
- Re: [sqlite] Enforcing uniqueness from multiple indexes Nico Williams