To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Tue, June 22, 2010 3:45:26 PM
Subject: Re: [sqlite] marking transaction boundaries
On 22 Jun 2010, at 10:25pm, b s wrote:
I want to mark that the following records inserted or updated
belong to a certain transaction
Database sqlite-users@sqlite.org
Sent: Wed, June 23, 2010 2:40:53 AM
Subject: Re: [sqlite] marking transaction boundaries
The question following your suggestion is how do i maintain transaction
start and stop times? I have no control of knowing when a transaction
starts and ends and i said
On 23 Jun 2010, at 5:19pm, b s wrote:
I don't know when transaction
begins or ends!
You are still ignoring the fact that transactions can be nested. One specific
INSERT command might be a member of three different transactions. Your model
allows only for one transaction per command.
If
AM
Subject: Re: [sqlite] marking transaction boundaries
On 23 Jun 2010, at 5:19pm, b s wrote:
I don't know when transaction
begins or ends!
You are still ignoring the fact that transactions can be nested. One specific
INSERT command might be a member of three different transactions. Your
On 23 Jun 2010, at 5:56pm, b s wrote:
I get the point that transactions can be nested and i am assuming
the begin transaction trigger only happens at the outer most transaction.
It still is the logical envelope which will be rolled back on a default abort.
(yes, i know one can back off to a
: [sqlite] marking transaction boundaries
On 23 Jun 2010, at 5:19pm, b s wrote:
I don't know when transaction
begins or ends!
You are still ignoring the fact that transactions can be nested. One
specific INSERT command might be a member of three different transactions.
Your model allows
On 23 Jun 2010, at 6:14pm, David Bicking wrote:
Did I miss Sqlite getting nested transactions?
I thought it only had one transaction, in which you can have multiple
savepoints, which are kind of sort of like nested transactions, but they use
SAVEPOINT and not BEGIN. Doesn't an abort
I don't understand the driver for this but have you considered creating
a function that would be called as part of the insert or trigger that
would have greater access to application/sqlite internal info that might
be used to create a transaction id.
On Tue, Jun 22, 2010 at 08:35:14AM -0700, b s wrote:
hi,
long ago, drh had proposed a trigger like mechanism that
can be invoked at the begin/end of a transaction.
http://osdir.com/ml/db.sqlite.general/2003-04/msg00137.html
the general consensus was there is no use other than up'ng
a
On Wed, Jun 23, 2010 at 09:19:05AM -0700, b s scratched on the wall:
I can put the transaction identifier into tables via triggers.
That's the million $ question. I don't know when transaction
begins or ends! And my original question was pointing to
a feature DRH had suggested way back in
- Original Message
From: Jay A. Kreibich j...@kreibi.ch
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Wed, June 23, 2010 11:15:59 AM
Subject: Re: [sqlite] marking transaction boundaries
On Wed, Jun 23, 2010 at 09:19:05AM -0700, b s scratched on the wall:
I
other existing semantics.
thanks
brs
- Original Message
From: Nicolas Williams nicolas.willi...@oracle.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Wed, June 23, 2010 9:39:17 AM
Subject: Re: [sqlite] marking transaction boundaries
On Tue, Jun 22, 2010
hi,
long ago, drh had proposed a trigger like mechanism that
can be invoked at the begin/end of a transaction.
http://osdir.com/ml/db.sqlite.general/2003-04/msg00137.html
the general consensus was there is no use other than up'ng
a counter. however, i have a requirement where i would like
to mark
Do you want to put that blob into all tables using a trigger or
changing all applications using database? If changing applications
then you can also change them to create that blob value. If using a
trigger then you can insert into that trigger creation of the blob
value if it doesn't exist. Is
of SQLite Database sqlite-users@sqlite.org
Sent: Tue, June 22, 2010 12:34:16 PM
Subject: Re: [sqlite] marking transaction boundaries
Do you want to put that blob into all tables using a trigger or
changing all applications using database? If changing applications
then you can also change them to create
On 22 Jun 2010, at 10:25pm, b s wrote:
I want to mark that the following records inserted or updated
belong to a certain transaction.
Transactions can be nested. In other words, an INSERT or UPDATE can belong to
more than one transaction. BLOBs are hugely expensive in terms of programming,
and i said earlier, i cannot use transaction hooks.
thanks
brs
- Original Message
From: Simon Slavin slav...@bigfraud.org
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Tue, June 22, 2010 3:45:26 PM
Subject: Re: [sqlite] marking transaction boundaries
On 22 Jun
17 matches
Mail list logo