Re: [sqlite] Constraint failed infos

2011-08-11 Thread Richard Hipp
On Thu, Aug 11, 2011 at 10:09 AM, Pavel Ivanov  wrote:

> This is a known issue and it has an open ticket:
> http://www.sqlite.org/src/tktview?name=23b2128201.
>

It is a known "feature request".  It is not a bug.

There is a lot of additional overhead involved in keeping track of names of
constraints and formatting detailed error messages showing specifically
which constraint failed.  We could do so, but it would come at the cost of
slower performance, increased code footprint, increased run-time memory
usage, and increased code complexity.  I remain unconvinced that the
improved error messages are worth the cost.


>
> Pavel
>
>
> On Wed, Aug 10, 2011 at 1:05 PM, Julien Laffaye  wrote:
> > Hello,
> >
> > Is it possible to get more info when I get a constraint failed error
> > from the C API?
> > I am interested in the column name, table name and type of constraint.
> >
> > Regards,
> > Julien
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Constraint failed infos

2011-08-11 Thread Pavel Ivanov
This is a known issue and it has an open ticket:
http://www.sqlite.org/src/tktview?name=23b2128201.

Pavel


On Wed, Aug 10, 2011 at 1:05 PM, Julien Laffaye  wrote:
> Hello,
>
> Is it possible to get more info when I get a constraint failed error
> from the C API?
> I am interested in the column name, table name and type of constraint.
>
> Regards,
> Julien
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Constraint failed infos

2011-08-10 Thread Julien Laffaye
Hello,

Is it possible to get more info when I get a constraint failed error 
from the C API?
I am interested in the column name, table name and type of constraint.

Regards,
Julien
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users