doc said trigger name can not be schema-qualified, we can not do: CREATE TRIGGER public.modified_a BEFORE UPDATE OF a ON main_table FOR EACH ROW WHEN (OLD.a <> NEW.a) EXECUTE PROCEDURE trigger_func('modified_a');
+ nameList = textToQualifiedNameList(trgName);
I am wondering if adding an error message if someone inserted a schema name would be advantageous?
It might be advantageous to show a `trigger name cannot be schema qualified` error to the user. Therefore, I added the check and the tests on v8 attached.
postgres=# SELECT pg_get_trigger_ddl('main_table', 'public.modified_a'); ERROR: trigger name cannot be schema qualified