Greetings,
This is my first time posting to this list, so I am not sure if this is
the correct list or not for this request. If it is not, please let me
know the best place for it.
Version 3.7.12 has added the following feature:
"Report the name of specific CHECK constraints that fail."
SQLite should also do the same for unique constraints.
Example:
create table tbl (
name varchar(100),
constraint uniq_name unique(name)
);
insert into tbl values("john");
insert into tbl values("george");
insert into tbl values("john");
Error: near line 9: column name is not unique
Add another constraint to this table:
constraint len_name check (length(name) < 5)
When you rerun the same sql statements you will get this error:
Error: near line 9: constraint len_name failed
I'd like to see something similar for unique constraints, where you are
actully told the name of the unique constraint that failed:
Error: near line 9: constraint uniq_name failed
Since patching SQLite is beyond my programming capability, how would I
best go about getting this added into the program?
Thanks,
-John Taylor
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
