Clojurians Log v2
Clojure programming
Channels
Apps
sql
All things SQL and JDBC...
2020-04-02T14:40:30.136100Z
["INSERT INTO t (a, b) VALUES (?, ?)" 1 "DEFAULT"]DEFAULT without quotes (not a string, a SQL keyword) ?
I have a similar problem with a PostGIS type (`geography`) but I think the issue is the same. 2020-04-02T14:42:06.136600Z
I am looking at PGobject.setType but I can’t find a suitable type
2020-04-02T14:58:29.137Z
having a look at postgis-java
kirill.salykin 2020-04-02T14:59:16.137700Z
you just don’t insert b - and db will use default value
2020-04-02T15:00:03.138100Z
I am aware - however my real issue is with the postgis data, I just think this is the same problem
2020-04-02T15:01:23.138400Z
hmm they look old - https://mvnrepository.com/artifact/org.postgis
2020-04-02T15:01:49.138600Z
ah https://mvnrepository.com/artifact/net.postgis/postgis-jdbc 🙂
dharrigan 2020-04-02T18:21:23.138800Z
postgis java is at 2.5.0
dharrigan 2020-04-02T18:21:27.139100Z
came out a few days ago
dharrigan 2020-04-02T18:21:43.139300Z
4 to be precise
2020-04-02T18:40:30.139700Z
yes, seems that it works (at least I can insert data)
2020-04-02T19:18:17.141100Z
org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connectionsreseting I get the above.
Does that mean I am not closing my connections properly on stop?
2020-04-02T20:02:08.141200Z
That's likely the explanation, yeah.