That is exactly the problem: such limits are app-specific logic, and that
3rd-party db manager cannot know about app-specific logic.

No, that is a metadata which belongs to the DB.

Forcing this pragma to always apply would in fact hinder some cases, e.g. creating a backup copy of a table using CREATE TABLE ... AS SELECT ... could violate the space constraint.

That is the problem of the DB manager(s). Such programs already have to be very cautious and smart to perform complex operations on tables/DBs. They still can disable the pragma temporarily while they need it tobe OFF.


--
<mailto:j...@q-e-d.org>j...@antichoc.net
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to