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
for each statement
call cardant.item_locations_enforce_counts ()
--
.. Where cardant.item_locations_enforce_counts is a JDBC/Java method
that tries to check the rows of new_item_locations. Unfortunately,
doing so just results in:
java.sql.SQLSyntaxErrorException: Table/View 'NEW_ITEM_LOCATIONS' does
not exist.
--
Mark Raynsford | https://www.io7m.com
pgpf08clENHM4.pgp
Description: OpenPGP digital signature
