[sqlite] problems with .dump procedure

[Roberto Davico]

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?

thanks all for any advice...

ciao
Roberto

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------