On 5/11/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Vivien Malerba" <[EMAIL PROTECTED]> wrote:
> Hi!
>
> In a single process, I open two connections (C1 and C2) to the same
> database (this is actually a corner case which could happen) and the
> following sequence of operations fail:
> 1-
"Vivien Malerba" <[EMAIL PROTECTED]> wrote:
> Hi!
>
> In a single process, I open two connections (C1 and C2) to the same
> database (this is actually a corner case which could happen) and the
> following sequence of operations fail:
> 1- on C1 execute "CREATE table actor (...)" => Ok
> 2- on C1
Is C1 in transaction? If it is, commit will enable C2 'see' the new table.
regards,
Radzi.
- Original Message -
From: "Vivien Malerba" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, May 11, 2007 4:19 PM
Subject: [sqlite] Multiple connection
Vivien Malerba wrote:
Hi!
In a single process, I open two connections (C1 and C2) to the same
database (this is actually a corner case which could happen) and the
following sequence of operations fail:
1- on C1 execute "CREATE table actor (...)" => Ok
2- on C1 execute "SELECT * FROM actor" =>
Hi!
In a single process, I open two connections (C1 and C2) to the same
database (this is actually a corner case which could happen) and the
following sequence of operations fail:
1- on C1 execute "CREATE table actor (...)" => Ok
2- on C1 execute "SELECT * FROM actor" => Ok
3- on C2 execute
5 matches
Mail list logo