[sqlite] DDL statements in transactions

> On Wed, Jun 11, 2008 at 3:55 PM, Robert Lehr 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

Re: [sqlite] DDL statements in transactions

On Wed, Jun 11, 2008 at 3:55 PM, Robert Lehr <[EMAIL PROTECTED]> wrote: > Oracle does not allow DDL statements to be executed in transactions, > i.e., it does but the statements are COMMITted as they are executed, > thus cannot be rolled back. > > PostgreSQL does allow DDL statements to be

Re: [sqlite] DDL statements in transactions

Robert Lehr wrote: > Oracle does not allow DDL statements to be executed in transactions, > i.e., it does but the statements are COMMITted as they are executed, > thus cannot be rolled back. > > PostgreSQL does allow DDL statements to be executed in transactions, > i.e., if a DDL query fails then

[sqlite] DDL statements in transactions

Oracle does not allow DDL statements to be executed in transactions, i.e., it does but the statements are COMMITted as they are executed, thus cannot be rolled back. PostgreSQL does allow DDL statements to be executed in transactions, i.e., if a DDL query fails then then entire transaction is