[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Call for testing experimental patch
- Subject: Re: Call for testing experimental patch
- From: "Chris Travers" <..hidden..>
- Date: Tue, 12 Sep 2006 23:01:19 -0700
If the id is duplicate, it will violate the unique constraint on the
shadow table (id_tracker) when it is inserted and the transaction will
fail.
Or am I missing something?
On 9/12/06, David Tangye <..hidden..> wrote:
On Mon, 2006-09-11 at 22:49 -0700, Chris Travers wrote:
> This patch will hopefully get included with the next version but I
> want to put it through some more vetting first. I am testing it on my
> production machines.
>
> What it does is install a shadow table with a primary key index which
> ensures that transaciton id's are unique across tables. I see no
> concerns about integrity of production data.
>
> Ideas and feedback are welcome.
I can see that the script is some DDL to create a table that will have
rows of id's that are duplicates of those inserted or updated as of the
point in time that the script is 'installed'. I am scratching my head to
figure out how that will ensure that transaction id's are unique across
tables. Its just some duplicated data isn't it?
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel