On Tue, Aug 30, 2011 at 6:15 PM, Jean-Christophe Deschamps <j...@antichoc.net > wrote:
> I also hope this can get changed someday, as this particular pragma can > have a devastating effect when the schema expects it to be set and you're > using a third-party manager (not your well coded application[s]) and you > inadvertantly forget to set it first. > That is exactly the problem: such limits are app-specific logic, and that 3rd-party db manager cannot know about app-specific logic. 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. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
