postgresql – 带有多个PK insertOrUpdate()的Scala的Slick抛出

case class Report(f1: DateTime,f2: String,f3: Double)

class Reports(tag: Tag) extends Table[Report](tag,"Reports") {
    def f1 = column[DateTime]("f1")
    def f2 = column[String]("f2")
    def f3 = column[Double]("f3")

    def * = (f1,f2,f3) <> (Report.tupled,Report.unapply)
    def pk = primaryKey("pk_report",(f1,f2))
}

val reports = TableQuery[Reports]

当我有空表并使用reports.insert(报告)时它运作良好.
但是当我使用reports.insertOrUpdate(report)时,我收到并且异常：

Exception in thread "main" org.postgresql.util.PSQLException: ERROR: syntax error at end of input
  Position: 76
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at ....

我究竟做错了什么？怎么解决？

提前致谢.

PS.我尝试了解决方法 – 尝试通过以下方式实现“if exist update else insert”逻辑：

val len = reports.withFilter(_.f1 === report.f1).withFilter(_.f2 === report.f2).length.run.toInt
                    if(len == 1) {
                        println("Update: " + report)
                        reports.update(report)
                    } else {
                        println("Insert: " + report)
                        reports.insert(report)
                    }

但是我仍然在更新时遇到异常：

Exception in thread "main" org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pk_report"
  Detail: Key ("f1",f2)=(2014-01-31 04:00:00,addon_io.aha.connect) already exists.