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