Shadowtable trigger names are being cut if are being longer than 63 characters
I've created two tables:
CREATE TABLE IF NOT EXISTS btracker_app.current_account_withdraws
(
account INT NOT NULL,
vesting_withdraw_rate BIGINT DEFAULT 0,
to_withdraw BIGINT DEFAULT 0,
withdrawn BIGINT DEFAULT 0,
withdraw_routes BIGINT DEFAULT 0,
CONSTRAINT pk_current_account_withdraws PRIMARY KEY (account)
) INHERITS (hive.btracker_app);
CREATE TABLE IF NOT EXISTS btracker_app.current_account_withdraws_routes
(
account INT NOT NULL,
to_account INT NOT NULL,
percent INT NOT NULL,
CONSTRAINT pk_current_account_withdraws_routes PRIMARY KEY (account, to_account)
) INHERITS (hive.btracker_app);
And HAF created only one trigger for those tables hive.hive_on_table_trigger_insert_btracker_app_current_account_withd()
first letters of those tables are similar and postgres seems to cut names over 63 letters so result trigger function is the same for both tables and the function is being triggered for both tables
Edited by Michal Zander