Re: Logging changes?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Jan 02 2008 - 11:41:20 EST

  • Next message: Michael Gentry: "Re: Logging changes?"

    Found one issue with the new logging today - insert queries with auto
    incremented PK incorrectly shift the labels to include the PK. E.g.,
    assuming auto-increment PK column name is "C2":

    INSERT INTO mytable (C1, C3, C4) VALUES (?, ?, ?)
    [bind: 1->C1:V1, 2->C2:V3, 3->C3:V4]

    At position #2, the PK label that is not used in the statement SQL is
    shown, and from there, all the values are off by one position.

    Andrus

    On Dec 28, 2007, at 5:07 PM, Michael Gentry wrote:

    > That's what I was hoping. Thanks for the update!
    >
    > /dev/mrg
    >
    > On Dec 28, 2007 9:53 AM, Andrus Adamchik <andru..bjectstyle.org>
    > wrote:
    >> I deployed this in production some time back. I am really happy with
    >> the new format - makes log analysis much easier.
    >>
    >> Cheers,
    >> Andrus
    >>
    >>
    >> On Nov 30, 2007, at 4:39 AM, Michael Gentry wrote:
    >>
    >>> Changes are checked in. Please let me know if you have problems,
    >>> etc.
    >>>
    >>> Thanks,
    >>>
    >>> /dev/mrg
    >>>
    >>
    >>
    >



    This archive was generated by hypermail 2.0.0 : Wed Jan 02 2008 - 11:41:51 EST