Re: [sqlite] Cannot drop trigger

[D. Richard Hipp]

Kurt Welgehausen wrote:
  sqlite> drop trigger xx;
  SQL error: no such trigger: xx
  sqlite> select name, length(name) from sqlite_master
     ...> where type='trigger' and name like '%xx%';
  xx|2
  sqlite> pragma integrity_check;
  ok
I had to dump the database and recreate it to get rid of
the trigger.
The problem is that the definition of trigger XX occurs
in the sqlite_master table before the definition of table
SCORES.
  SELECT rowid, type, tbl_name, name FROM sqlite_master

    29|trigger|scores|xx
    30|table|Scores|Scores
    31|index|Scores|(Scores autoindex 1)
    32|index|Scores|Scores_ShNum
    33|index|Scores|Scores_StNum
You must have had a previous table named "scores" put the
trigger 'xx' on that table, then deleted "scores" and
recreated it as "Scores".  But that should have cleared
the trigger "xx".
I don't know how you managed to get SQLite into the state
that it is in.  If you can reproduce it let me know.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]