Re: Release changes

How are statement level triggers supposed to work? Are they just
triggers deferred until the end of the statement? You mentioned access
to the affected rows, but I don't understand how that is supposed to
happen.

---------------------------------------------------------------------------

Andreas Pflug wrote:
> Thinking hard about wording...
>
> Add partially implemented FOR EACH STATEMENT statement-level triggers (Neil Conway)
>
>
> which doesn't look nice but expresses what's implemented. Taken from the
> CREATE TRIGGER FOR EACH STATEMENT documentation, a user would think he
> could do the same stuff as on lets say MSSQL, in a way known from
> row-level triggers. The example trigger-example.html seems to be
> non-statement-level trigger aware. Chapter 37 is quite misleading, for
> example recursive triggers are mentioned "programmer's responsibility to
> avoid infinite recursion"suggesting there would be a way to know about
> the affected rows...
>
> Actually, I'd consider not to mention statement triggers at all. In the
> current state, they will provoke some annoyance if people try to use
> them. We will see them on the mailing lists, seeking for what's
> currently not available...
>
> Regards,
> Andreas
>
> Bruce Momjian wrote:
>
> >Do you have suggested wording?
> >
> >---------------------------------------------------------------------------
> >
> >Andreas Pflug wrote:
> >
> >
> >>Bruce Momjian wrote:
> >>
> >>
> >>
> >>>Here are the changes for 7.4. I am looking for any improvements. This
> >>>will be adjusted as we move through beta.
> >>>
> >>>---------------------------------------------------------------------------
> >>>Add FOR EACH STATEMENT statement-level triggers (Neil Conway)
> >>>
> >>>
> >>>
> >>AFAICS the current implementation still doesn't have a way to access the
> >>affected rowset, so it'a pretty much like a SELECT without a WHERE. This
> >>restricts the usability of statement-level triggers to very limited
> >>cases. IMHO it's not a good idea to announce an incompletely implemented
> >>feature.
> >>
>
>
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073