Postgres Trigger getActionStatement not returning expected body about schemacrawler HOT 4 CLOSED

@JessicaF I will fix this issue. It may need a change to the catalog model for triggers.

from schemacrawler.

@JessicaF Please use SchemaCrawler v16.21.1

from schemacrawler.

@JessicaF SchemaCrawler provides information from information_schema.triggers, which in your case, is simply EXECUTE FUNCTION last_updated(). The definition of public.last_updated() will be provided along with other details of the function. Please make sure that you are crawling routines also, in your code. By default, SchemaCrawler does not crawl routines.

from schemacrawler.

Thank you for your response! I've found another potential issue within the same database but for a different trigger:

CREATE TRIGGER film_fulltext_trigger
    BEFORE INSERT OR UPDATE 
    ON public.film
    FOR EACH ROW
    EXECUTE FUNCTION tsvector_update_trigger('fulltext', 'pg_catalog.english', 'title', 'description');

The getActionStatement method is returning

EXECUTE FUNCTION tsvector_update_trigger('fulltext', 'pg_catalog.english', 'title', 'description')EXECUTE FUNCTION tsvector_update_trigger('fulltext', 'pg_catalog.english', 'title', 'description')

The expected output is just
EXECUTE FUNCTION tsvector_update_trigger('fulltext', 'pg_catalog.english', 'title', 'description')

from schemacrawler.