Re: [sqlite] Get transaction number

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

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 it

Re: [sqlite] Get transaction number

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 Tandetnik

Re: [sqlite] Get transaction number

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 wo

Re: [sqlite] Get transaction number

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. A

Re: [sqlite] Get transaction number

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 t

Re: [sqlite] Get transaction number

"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 any

Re: [sqlite] Get transaction number

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

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. > __

[sqlite] Get transaction number

Hello! How can I get transaction identifier or number (my programm lang is tcl)? Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users