Re: Transaction ID

Article View: borland.public.interbase.sql

Article #939

Back to borland.public.interbase.sql Previous Next

#939

From: Bill Todd
Date: Sat, 05 May 2007 13:49

13 lines
1449 bytes

Shahid Iqbal wrote:

> hope u understand.

Sorry but I do not understand. What use is the integer transaction id?
You have the timestamp to show the order of the log entries. If you
want an arbitrary integer to also show the order use a generator. The
transaction id contains no information that is of use after the
transaction has ended. Assume that someone looks at your log table
later? What will the transaction id tell them?

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <463c8b72@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<46398310@newsgroups.borland.com> <4639d52d$1@newsgroups.borland.com> <463abe99@newsgroups.borland.com> <463b499e$1@newsgroups.borland.com> <463c0ba3@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,d90274d8031a6000
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Transaction ID
Newsgroups: borland.public.interbase.sql
References: <46398310@newsgroups.borland.com> <4639d52d$1@newsgroups.borland.com> <463abe99@newsgroups.borland.com> <463b499e$1@newsgroups.borland.com> <463c0ba3@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <463c8b72@newsgroups.borland.com>
Date: 5 May 2007 06:49:38 -0700
X-Trace: newsgroups.borland.com 1178372978 216.207.211.19 (5 May 2007 06:49:38 -0700)
Lines: 13
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message