Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

2019-06-19 Thread Kevin Benson
On Wed, Jun 19, 2019 at 12:12 PM Carsten Müncheberg < carsten.muencheb...@native-instruments.de> wrote: > Am 19.06.2019 um 16:47 schrieb Igor Tandetnik: > > On 6/19/2019 10:39 AM, Carsten Müncheberg wrote: > >> Is there really something like a table lock? > > > > Yes there is:

Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

2019-06-19 Thread Carsten Müncheberg
Am 19.06.2019 um 16:47 schrieb Igor Tandetnik: On 6/19/2019 10:39 AM, Carsten Müncheberg wrote: Is there really something like a table lock? Yes there is: https://sqlite.org/sharedcache.html Thanks, I wasn't aware of that. -- Carsten Müncheberg Software Developer Native Instruments GmbH

Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

2019-06-19 Thread Simon Slavin
On 19 Jun 2019, at 3:39pm, Carsten Müncheberg wrote: > /* SQLITE_BUSY*/ "database is locked", > /* SQLITE_LOCKED */ "database table is locked", With two different connections, either by the same program or different programs/computers, you will see SQLITE_BUSY . SQLITE_BUSY is

Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

2019-06-19 Thread Igor Tandetnik
On 6/19/2019 10:39 AM, Carsten Müncheberg wrote: Is there really something like a table lock? Yes there is: https://sqlite.org/sharedcache.html -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] SQLITE_LOCKED means "database table is locked"?

2019-06-19 Thread Carsten Müncheberg
I'm puzzled by the error strings for SQLITE_BUSY and SQLITE_LOCKED. The documentation for both is very clear and precise, but these too strings which are returned by sqlite3_errmsg() are misleading in my opinion, especially "database table is locked". Is there really something like a table