Re: [sqlite] CREATE IF NOT EXISTS and locks

2006-07-12 Thread drh
Iker Arizmendi <[EMAIL PROTECTED]> wrote: > When a statement of the form: > > CREATE TABLE xxx IF NOT EXISTS > > what sort of locking overhead is incurred in the case > where the table already exists? > If the table already exists, no locking occurs. The statement above is a no-op. -- D.

[sqlite] CREATE IF NOT EXISTS and locks

2006-07-12 Thread Iker Arizmendi
When a statement of the form: CREATE TABLE xxx IF NOT EXISTS what sort of locking overhead is incurred in the case where the table already exists? Regards, Iker -- Iker Arizmendi e: [EMAIL PROTECTED] w: ikerariz.blogspot.com