Hi, I'm seeing this error when passing a vector to be written to a Postgresql jsonb column: org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of clojure.lang.PersistentVector. I'm not sure why the type and protocol extensions in db.core are not handling this. Maps work fine. Any ideas?

@shanekilkelly that looks like it just might be chrome cache, try clearing it and see if the issue goes away

Will do

this was with the +postgres and +scss switches

hmm the +scss switch might affect it, it might not have been updated to use the latest css for bootstrap 4

@v47 I think you might need to update this

(extend-type clojure.lang.IPersistentVector
  jdbc/ISQLParameter
  (set-parameter [v ^java.sql.PreparedStatement stmt ^long idx]
    (let [conn      (.getConnection stmt)
          meta      (.getParameterMetaData stmt)
          type-name (.getParameterTypeName meta idx)]
      (if-let [elem-type (when (= (first type-name) \_) (apply str (rest type-name)))]
        (.setObject stmt idx (.createArrayOf conn elem-type (to-array v)))
        (.setObject stmt idx (to-pg-json v))))))

@yogthos Yup, that was it, thanks! When the type is extended for ISQLParameter, is the ISQLValue protocol extension superfluous?

(extend-protocol jdbc/ISQLValue
       IPersistentMap
       (sql-value [value] (to-pg-json value))
       IPersistentVector
       (sql-value [value] (to-pg-json value)))

Yeah I think so