> On Wed, Jun 11, 2008 at 3:55 PM, Robert Lehr <rlehr at cadence.com> wrote: > > > Oracle does not allow DDL statements [ ... snippage ... ] > > > > PostgreSQL does allow DDL statements [ ... snippage ... ] > > > > Which behaviour is implemented in SQLite? > >
> On Wed, Jun 11, 2008 at 4:33 PM, Stephen Oberholtzer <oliverklozoff at gmail.com> wrote: > > Let's find out! > > C:\temp>sqlite3 > SQLite version 3.5.9 > Enter ".help" for instructions > sqlite> create table foo (id integer, name text); > > [ ... snippage ... ] > (A) my apologies for any confusion from me not replying in the thread. however, i cannot reply to the thread b/c, afaik, i am not receiving the mailing emails. i have no idea why; i am getting the digests and the spam filters show no other sqlite-users emails. maybe i am missing something else there. (at least, i provided proper context this time :D ) (B) thanks for the suggestions. however, i am seeking a definitive answer, not an empirical one. my question was inspired when i executed a "CREATE TABLE" and "CREATE INDEX" inside a transaction. the "CREATE TABLE" executed just fine. the "CREATE INDEX" abort w/ a "table does not exist" error (or something to that affect. of course, when they were executed w/o a transaction, both ran just fine. -rlehr Robert Lehr _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
