Re: [sqlite] Syntax error on CREATE TRIGGER IF NOT EXISTS

sqlite 3.3.6. I didn't realize it was so old. Thanks. Igor Tandetnik wrote: > Jim Terman wrote: > >> It looks like to me that CREATE TRIGGER IF NOT EXISTS is recognized by >> sqlite, but I get the following from the command line: >> >> sqlite> CREATE TABLE foo (id INTEGER

Re: [sqlite] Syntax error on CREATE TRIGGER IF NOT EXISTS

Jim Terman wrote: > It looks like to me that CREATE TRIGGER IF NOT EXISTS is recognized by > sqlite, but I get the following from the command line: > > sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, value TEXT, > timestamp DATE);sqlite> CREATE TRIGGER IF NOT EXISTS foo_log

[sqlite] Syntax error on CREATE TRIGGER IF NOT EXISTS

It looks like to me that CREATE TRIGGER IF NOT EXISTS is recognized by sqlite, but I get the following from the command line: sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, value TEXT, timestamp DATE);sqlite> CREATE TRIGGER IF NOT EXISTS foo_log AFTER INSERT ON foo BEGIN INSERT INTO foo