Re: [sqlite] Get transaction number

2008-08-26 Thread Kees Nuyt
On Tue, 26 Aug 2008 20:11:05 +0400, you wrote: >Hello! > >? ? ?? Tuesday 26 August 2008 18:59:55 Igor Tandetnik ???(?): >> > I don't know method to set triggers on begin and commit transaction >> > events. >> >> You could log begin/end transaction (along with any other statements) by

Re: [sqlite] Get transaction number

2008-08-26 Thread Alexey Pechnikov
Hello! В сообщении от Tuesday 26 August 2008 21:24:24 Igor Tandetnik написал(а): > > Thanks, it's better way for my task. But is it safe to logging > > uncommited changes? > > You tell me. Aren't your triggers doing that already? Well, if I'm writing log to other database in single transaction

Re: [sqlite] Get transaction number

2008-08-26 Thread Igor Tandetnik
Alexey Pechnikov <[EMAIL PROTECTED]> wrote: >> By the way, see sqlite3_update_hook. Perhaps you could use that in >> lieu of your triggers. > > Thanks, it's better way for my task. But is it safe to logging > uncommited changes? You tell me. Aren't your triggers doing that already? Igor

Re: [sqlite] Get transaction number

2008-08-26 Thread Alexey Pechnikov
Hello! В сообщении от Tuesday 26 August 2008 18:59:55 Igor Tandetnik написал(а): > > I don't know method to set triggers on begin and commit transaction > > events. > > You could log begin/end transaction (along with any other statements) by > installing sqlite3_trace hook. > > Another approach

Re: [sqlite] Get transaction number

2008-08-26 Thread Igor Tandetnik
Alexey Pechnikov <[EMAIL PROTECTED]> wrote: > ÷ ÓÏÏÂÝÅÎÉÉ ÏÔ Tuesday 26 August 2008 16:44:56 Igor Tandetnik > ÎÁÐÉÓÁÌ(Á): >>> Can I group logged queries by any transaction id? >> >> Well, BEGIN TRANSACTION and END TRANSACTION are themselves queries, >> and thus will presumably appear in your log.

Re: [sqlite] Get transaction number

2008-08-26 Thread Alexey Pechnikov
Hello! В сообщении от Tuesday 26 August 2008 16:44:56 Igor Tandetnik написал(а): > > Can I group logged queries by any transaction id? > > Well, BEGIN TRANSACTION and END TRANSACTION are themselves queries, and > thus will presumably appear in your log. Any queries in between would > then belong

Re: [sqlite] Get transaction number

2008-08-26 Thread Igor Tandetnik
"Alexey Pechnikov" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Â ñîîáùåíèè îò Tuesday 26 August 2008 15:58:56 Jeffrey Becker > íàïèñàë(à): >> I dont believe sqlite supports named transactions. As such there >> wouldnt be any identifier to get. > > Can I group logged queries by

Re: [sqlite] Get transaction number

2008-08-26 Thread Alexey Pechnikov
Hello! В сообщении от Tuesday 26 August 2008 15:58:56 Jeffrey Becker написал(а): > I dont believe sqlite supports named transactions.  As such there > wouldnt be any identifier to get. Can I group logged queries by any transaction id? Best regards, Alexey.

Re: [sqlite] Get transaction number

2008-08-26 Thread Jeffrey Becker
I dont believe sqlite supports named transactions. As such there wouldnt be any identifier to get. On Tue, Aug 26, 2008 at 4:47 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote: > Hello! > > How can I get transaction identifier or number (my programm lang is tcl)? > > Best regards, Alexey. >