On 2021-08-13T13:26:47 -0700
Richard Hillegas 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
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.
Hello!
Is it supposed to be possible to access the transitional tables
produced in triggers? For example, I need to write the following:
--
create trigger cardant.item_locations_enforce_counts_update_trigger
after update on cardant.item_locations
referencing old_table as new_item_locations