current_timestamp() as default value gets not migrated from mariadb to postgresql

[Triggsy22]

In a migration from mariadb to postgresql, when a column in mariadb has default of current_timstamp(), this default value gets not transfered to postgresql. Instead it gets no default value at all.

MariaDB Version: 10.3.38 PostgreSQL Version: 12.15

From the Log Files:

SQL: ALTER TABLE "public"."directus_files" ALTER COLUMN "modified_on" SET DEFAULT 'current_timestamp()'; --[DefaultProcessor::default] error: invalid input syntax for type timestamp: "current_timestamp()"

I think the real query should be: ALTER TABLE "public"."directus_files" ALTER COLUMN "modified_on" SET DEFAULT CURRENT_TIMESTAMP;