On Mon, Oct 14, 2013 at 6:02 AM, Philipp Kraus <
philipp.kr...@tu-clausthal.de> wrote:
>
> Am 14.10.2013 um 11:49 schrieb Alban Hertroys :
>
> > On Oct 14, 2013, at 8:18, Philipp Kraus
> wrote:
> >
> >> Hello,
> >>
> >> I have written a update & delete trigger of a table.
> >> My delete trigger r
Am 14.10.2013 um 11:49 schrieb Alban Hertroys :
> On Oct 14, 2013, at 8:18, Philipp Kraus wrote:
>
>> Hello,
>>
>> I have written a update & delete trigger of a table.
>> My delete trigger runs an update statement but this create a (semantic)
>> problem.
>> How can I disable the update trigge
On Oct 14, 2013, at 8:18, Philipp Kraus wrote:
> Hello,
>
> I have written a update & delete trigger of a table.
> My delete trigger runs an update statement but this create a (semantic)
> problem.
> How can I disable the update trigger for only this update call within the
> delete trigger?
>
Hello
you can disable trigger by ALTER TABLE tablename DISABLE TRIGGER
triggername;
but it should be executed with owner rights on table.
This statement works perfect, but a fact, so you need it signalize so you
do some wrong. Triggers should to be used primary for checking, logging,
calculating
Hello,
I have written a update & delete trigger of a table.
My delete trigger runs an update statement but this create a (semantic) problem.
How can I disable the update trigger for only this update call within the
delete trigger?
So my delete trigger need not call the update trigger
Thanks
Phi
