Haskell (BLOOMBERG/ 731 LEXIN)
At: Apr 25 2013 16:38:27
Levi Haskell wrote: What was the motivation for this change (it seems
to be quite inconvenient in my case)? The previous method used to
deal with the non-deterministic finalization order imposed by the CLR did not
work reliably in all
Thank you Joe,
What was the motivation for this change (it seems to be quite inconvenient in
my case)?
- Levi
- Original Message -
From: sql...@mistachkin.com
To: sqlite-users@sqlite.org
Cc: Levi Haskell (BLOOMBERG/ 731 LEXIN)
At: Apr 25 2013 15:07:54
As of release 1.0.82.0
It seems that in version 1.0.81.0 and earlier the database file was released
immediately after all SQLiteConnection objects were disposed even if some
dependent SQLiteCommand and/or SQLiteDataReader objects were not yet disposed
or closed.
However starting version 1.0.82.0 the file remains
Hi Richard,
Downloaded the 3.7.16. I still don't see any mentioning of the optional table
argument to the foreign_key_check pragma in:
http://www.sqlite.org/pragma.html#pragma_foreign_key_check
Is this feature officially unsupported?
Thanks,
- Levi
Hi Richard,
I don't see any mentioning of the optional table argument to the
foreign_key_check pragma in:
http://www.sqlite.org/draft/pragma.html#pragma_foreign_key_check
For example:
SQLite version 3.7.16 2013-03-02 03:25:55
Enter ".help" for instructions
Enter SQL statements terminated with
Perfect! Exactly what I needed
Thanks a lot,
- Levi
- Original Message -
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN)
Cc: sqlite-users@sqlite.org
At: Jan 1 2013 09:03:00
On Thu, Dec 27, 2012 at 11:43 AM, Levi Haskell (BLOOMBERG/ 731 LEXIN)
<lh
evi
- Original Message -----
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN)
Cc: sqlite-users@sqlite.org
At: Dec 20 2012 23:05:20
On Thu, Dec 20, 2012 at 3:05 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN)
<lhask...@bloomberg.net> wrote:
Tested, works perfectly.
g the shell) I made a typo in the pragma name
While I don't have a better suggestion now, I just wanted to point it out to
you.
Again thanks a lot!
- Levi
- Original Message -----
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN), sqlite-users@sqlite.org
At: Dec 19 2012 21:10:
Agreed. I originally thought your complexity argument was against implementing
it inside SQLite.
- Levi
- Original Message -
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN), sqlite-users@sqlite.org
At: Dec 12 2012 16:28:43
On Wed, Dec 12, 2012 at 4:18 PM, Levi
Jos,
I see your point but another way to look at it is that PRAGMA foreign_keys=0/1
changes the definition of what constitutes a legal/consistent state of the
database, thus it makes sense that behavior of check_integrity PRAGMA would
change accordingly.
Thanks,
- Levi
- Original
On Wed, Dec 12, 2012 at 3:40 PM, Richard Hipp <d...@sqlite.org> wrote:
>On Wed, Dec 12, 2012 at 3:36 PM, Richard Hipp <d...@sqlite.org> wrote:
>> On Wed, Dec 12, 2012 at 2:29 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) <
>> lhask...@bloomberg.net> wrote:
>
Hello,
We have an application that relies heavily on SQLite foreign key feature to
ensure referential integrity of our database. Naturally we always enable
foreign key enforcement immediately after connecting. However periodically,
when we roll out new software (we have well over 300K
Alexander,
Just curious, how do you call Backup API from .NET (if you do)? AFAIK it's not
accessible through System.Data.SQLite.dll. Did you have to compile SQLite
separately from c sources?
Thank you,
- Levi
- Original Message -
From: sqlite-users@sqlite.org
To:
13 matches
Mail list logo