Spring Kotlin Postgres

Question

   @Entity
    @Table(name = "profiles")
    data class Profile(
    @Id
        @GeneratedValue(generator = "UUID")
        @GenericGenerator(
                name = "UUID",
                strategy = "org.hibernate.id.UUIDGenerator"
        )
        @Column(name = "id", updatable = false, nullable = false)
        val id: UUID,

    @Column(name = "first_name")
        var firstName: String? = null,

        @Column(name = "last_name")
        var lastName: String? = null,

    @Column(name = "phones")
        var phones: String? = null
}

在Postgres中有表配置文件和列'phones‘=> character varyingArray，我如何设置类型来更新和插入数据？

如果设置List<>或Array<> ArrayList<>，则会出现错误：

org.postgresql.util.PSQLException: ERROR: column "phones" is of type character varying[] but expression is of type character varying
  Hint: You will need to rewrite or cast the expression.

Answer 1

您是否正在尝试获取电话栏目中的日期？正如我所看到的，你正在尝试添加电话，字符串是它的正确类型，我会在postger中添加一个逻辑，在更新时添加一个新的日期。