Hi, I've noticed in alter.c, around about line 480 there is a direct reference to updating the sqlite_master table, rather than using the SCHEMA_TABLE macro.
I wondered whether this was a simple oversight, or by design? It means the following currently happens... sqlite> pragma foreign_keys=1; sqlite> create temp table x(i primary key); sqlite> create temp table y(i references x(i)); sqlite> insert into y values(1); Error: foreign key constraint failed sqlite> alter table x rename to z; sqlite> insert into y values(1); Error: no such table: temp.x Cheers, Will _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users