若依框架更换成postgresql，集成flyway问题

1、分页插件问题

修改配置问题

# PageHelper分页插件
pagehelper:
  helperDialect: postgresql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql

2、flyway报错 com.alibaba.druid.sql.parser.ParserException

09:08:44.859 [restartedMain] ERROR c.a.d.f.s.StatFilter - [mergeSql,150] - merge sql error, dbType postgresql, druid-1.2.16, sql : ALTER TABLE "qrtz_blob_triggers" ADD CONSTRAINT "QRTZ_BLOB_TRIGGERS_ibfk_1" FOREIGN KEY ("sched_name", "trigger_name", "trigger_group") REFERENCES "qrtz_triggers" ("sched_name", "trigger_name", "trigger_group") ON DELETE RESTRICT ON UPDATE RESTRICT
com.alibaba.druid.sql.parser.ParserException: syntax error, expect SET, actual RESTRICT pos 229, line 1, column 222, token RESTRICT
	at com.alibaba.druid.sql.parser.SQLExprParser.accept(SQLExprParser.java:4610)

com.alibaba.druid解析pg语法出现的错误，暂时没有好的处理方法。能规避错误的方法是修改配置文件中的filter.stat.merge-sql=false

  filter:
                stat:
                    enabled: true
                    # 慢SQL记录
                    log-slow-sql: true
                    slow-sql-millis: 1000
                    merge-sql: false

3、连接函数SQL报错

 # 配置检测连接是否有效
            validationQuery: SELECT version()