Github user dongjoon-hyun commented on a diff in the pull request: https://github.com/apache/spark/pull/19911#discussion_r155333091 --- Diff: sql/core/src/main/scala/org/apache/spark/sql/jdbc/PostgresDialect.scala --- @@ -100,5 +100,5 @@ private object PostgresDialect extends JdbcDialect { } - override def isCascadingTruncateTable(): Option[Boolean] = Some(true) + override def isCascadingTruncateTable(): Option[Boolean] = Some(false) --- End diff -- Spark don't use `CASCADE` at all. I'm wondering if your PR will not solve your problem. ```scala def truncateTable(conn: Connection, table: String): Unit = { val statement = conn.createStatement try { statement.executeUpdate(s"TRUNCATE TABLE $table") } finally { statement.close() } } ```
--- --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org