On Tue, 2007-06-19 at 09:42 +0200, Roberto Davico wrote: > Hi all, > > I am Roberto and I find a problem using sqlite3 (version: SQLite > version 3.3.8). > > I make a sample db to explain the situation: > > 1) Create the sample database using command line tool: > > sqlite> .schema > CREATE TABLE LOG (ID INTEGER PRIMARY KEY AUTOINCREMENT, MSG TEXT ); > CREATE TABLE USERS (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT, > SURNAME TEXT); > CREATE VIEW USR AS SELECT NAME FROM USERS; > CREATE TRIGGER USR_DELETE AFTER DELETE ON USERS BEGIN INSERT INTO LOG > (ID, MSG) VALUES( NULL, 'Cancellato utente'); END; > > > 2) Export with .dump command procedure > > sqlite> .output dumpo.txt > sqlite> .dump > sqlite> .output stdout > sqlite> .quit > > > 3) Analyze the dump file: > > ~$ cat dumpo.txt > BEGIN TRANSACTION; > CREATE TABLE USERS (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT, > SURNAME TEXT); > DELETE FROM sqlite_sequence; > CREATE TABLE LOG (ID INTEGER PRIMARY KEY AUTOINCREMENT, MSG TEXT ); > COMMIT; > > where are my view and trigger? > > Is it a problem on my handwork or it isn't possible to dump views or > triggers? are there many settings to do before dump?
It's an old bug: http://www.sqlite.org/cvstrac/tktview?tn=2044 You'll have to upgrade the sqlite version I think. Dan. > thanks all for any advice... > > ciao > Roberto > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
