On 2021-08-13T13:26:47 -0700 Richard Hillegas <[email protected]> wrote:
> Trigger transition tables can only be used for row-scoped triggers (FOR > EACH ROW triggers). They cannot be used for statement-scoped triggers (FOR > EACH STATEMENT triggers). I suppose that you could create a row-scoped > trigger which populates a scratch table from the values of the transition > table. Then you could create a statement-scoped trigger which fires a > database procedure to process the scratch table. Are you sure? The documentation seems to suggest otherwise: https://db.apache.org/derby/docs/10.15/ref/rrefsqlj43125.html "Note: Only statement triggers (see Statement versus row triggers) can use the transition tables. INSERT statement triggers cannot reference an OLD table. DELETE statement triggers cannot reference a NEW table." -- Mark Raynsford | https://www.io7m.com
pgpRegJSB2Xw9.pgp
Description: OpenPGP digital signature
