[sqlite] Trigger SQL and database schema

Hi, seems like SQLite is not checking trigger SQL for invalid column names until execution? Is there a way to force this check? The problem: trying to find out which indices, triggers and views depend on particular column. We can recreate table without this column and recompile indices, triggers

Re: [sqlite] Trigger SQL and database schema

Sqlite Dog wrote: seems like SQLite is not checking trigger SQL for invalid column names until execution? No. Is there a way to force this check? Not without compiling the respective INSERT/UPDATE/DELETE statement. The problem: trying to find out which indices, triggers and views depend on

[sqlite] Getting context information (ie db name) from within sqlite error callback

Hi, I have sqlite running with multiple connections to databases (and perhaps even multithreaded). I am using a simple error logging callback function to display additional information while I am hunting down a problem with some databases. What I really want to be able to do is have the error

Re: [sqlite] Segmentation Fault With Trigger

I'm not an sqlite3 dev, but I don't think you'll get much help until you provide enough information for somebody to see what is going wrong. You were already asked to provide a backtrace from a debug-compiled sqlite3 library (the backtrace you sent is all but useless). A self-contained .c

[sqlite] FTS4 + spellfix1 with multiple languages

Hi,   I have a FTS4 table that contains entries in multiple languages (using the languageid option). I also have a spellfix1 table that I use to search with misspelled words on the FTS4 table. In the spellfix1 documentation a fts4aux table is used to fill a spellfix1 table based on a FTS4 one.

Re: [sqlite] Segmentation Fault With Trigger

techi eth wrote: You should compile your code sqlite3.c with -g -O0 when sending a stack trace. Most likely, the bug is in your program. Since you're on Linux, try running with valgrind memcheck tool to find bugs (access to free memory, uninitialized memory, etc.) If you compile with clang-3.3

[sqlite] Pattern for using sqlite3_busy_timeout()

Hi, As I've learnt more about how to use SQLite (mainly from looking at this mailing list), I've realised I've coded somethings in a cough less than an optimal manner cough. One of the things I've realised is that SQLite has a timing system built into accessing the database, so that if things

[sqlite] System.Data.SQLite Deployment Problem

I'm having a terrible time trying to deploy my SQLite application. I downloaded from System.Data.SQLite.org the file: sqlite-netFx45-setup-bundle-x86-2012-1.0.88.0.exe and installed that on my development machine (Windows 7 Ultimate x64). I actually have 2 development machines, a laptop and a

Re: [sqlite] System.Data.SQLite Deployment Problem

Paul Bainter wrote: When I run the program on the target machine, the main window comes up fine because it doesn't access the database, but once I bring up a window that does access the database, I get a message stating that the application has stopped working. No error message specific to

Re: [sqlite] Trigger SQL and database schema

On 2013.10.14 11:58 PM, Sqlite Dog wrote: seems like SQLite is not checking trigger SQL for invalid column names until execution? What you describe sounds like the behavior of every SQL DBMS which has triggers whose trigger behavior I know. Seems better to me to retain this behavior than to

Re: [sqlite] Trigger SQL and database schema

On Oct 16, 2013, at 7:20 AM, Darren Duncan dar...@darrenduncan.net wrote: On 2013.10.14 11:58 PM, Sqlite Dog wrote: seems like SQLite is not checking trigger SQL for invalid column names until execution? What you describe sounds like the behavior of every SQL DBMS which has triggers