Re: capturing DDL change with a trigger

From: ddf <oratune_at_msn.com>
Date: Mon, 7 Apr 2014 07:51:04 -0700 (PDT)
Message-ID: <5796f9b9-52ae-483e-a9bf-07ecc2fda82a_at_googlegroups.com>

On Thursday, April 3, 2014 11:00:59 AM UTC-6, geos wrote:
> On 03.04.2014 16:48, ddf wrote:
>
> > The trigger won't capture that change because it's not posted until the alter table statement has completed successfully.
>
>
>
> Thanks David. So when does alter table is considered completed
>
> sucessfully? I'm kinda puzzled because the trigger is named AFTER ALTER
>
> and I thought it would fire after the ALTER is completed, not soemewhere
>
> in between... If the following is not true:
>
>
>
> -- implicit commit
>
> -- DDL statement
>
> -- implicit commit
>
> (here I thought DDL "was updated" in dictionary)
>
> -- after this DDL trigger starts and is able to see the changed DDL
>
>
>
> then what is?
>
>
>
> thank you,
>
> geos

It's after the ALTER executes but before the final implicit commit.

David Fitzjarrell Received on Mon Apr 07 2014 - 16:51:04 CEST