exception on postgresql array update

18 views
Skip to first unread message

gen...@gmail.com

unread,
Dec 14, 2016, 11:35:02 AM12/14/16
to SQL Workbench/J - DBMS independent SQL tool
hey thomas,

doing an update through the "database explorer" view, operating on a raw table, where at least one changed column is of type "col4 character varying(128)[] NOT NULL DEFAULT '{}'::character varying[]", produces the exception given below (only renamed the actual tab and col names/values for privacy). the insert works fine. versions at the bottom.
like it, regards peter

update tab set col4 = '{^some,strings,here}' where col1 = 123 and col2 = 123 and col3 = false;

2016-12-14 17:16:45 ERROR Thread + DwPanel update caused an exception org.postgresql.jdbc3g.Jdbc3gConnection.createArrayOf(Ljava/lang/String;[Ljava/lang/Object;)Ljava/sql/Array;
java.lang.AbstractMethodError: org.postgresql.jdbc3g.Jdbc3gConnection.createArrayOf(Ljava/lang/String;[Ljava/lang/Object;)Ljava/sql/Array;
at workbench.storage.DmlStatement.handleArray(DmlStatement.java:415)
at workbench.storage.DmlStatement.execute(DmlStatement.java:245)
at workbench.storage.DataStore.executeGuarded(DataStore.java:1754)
at workbench.storage.DataStore.updateDb(DataStore.java:1862)
at workbench.gui.sql.DwPanel.saveChanges(DwPanel.java:545)
at workbench.gui.dbobjects.TableDataPanel$1.saveChanges(TableDataPanel.java:172)
at workbench.gui.sql.DwPanel$1.run(DwPanel.java:507)

sql wb 121, sourced today
java 1.8.0 111
pgrs 9.3 linux
Reply all
Reply to author
Forward
0 new messages