{"action":"created","issue":{"url":"https://api.github.com/repos/serge-rider/dbeaver/issues/1217","repository_url":"https://api.github.com/repos/serge-rider/dbeaver","labels_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/1217/labels{/name}","comments_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/1217/comments","events_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/1217/events","html_url":"https://github.com/serge-rider/dbeaver/issues/1217","id":204660857,"number":1217,"title":"PostgreSQL: Data type Money not supported","user":{"login":"kaelte","id":10630145,"avatar_url":"https://avatars.githubusercontent.com/u/10630145?v=3","gravatar_id":"","url":"https://api.github.com/users/kaelte","html_url":"https://github.com/kaelte","followers_url":"https://api.github.com/users/kaelte/followers","following_url":"https://api.github.com/users/kaelte/following{/other_user}","gists_url":"https://api.github.com/users/kaelte/gists{/gist_id}","starred_url":"https://api.github.com/users/kaelte/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kaelte/subscriptions","organizations_url":"https://api.github.com/users/kaelte/orgs","repos_url":"https://api.github.com/users/kaelte/repos","events_url":"https://api.github.com/users/kaelte/events{/privacy}","received_events_url":"https://api.github.com/users/kaelte/received_events","type":"User","site_admin":false},"labels":[{"id":275893724,"url":"https://api.github.com/repos/serge-rider/dbeaver/labels/question","name":"question","color":"bfe5bf","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-02-01T18:09:59Z","updated_at":"2017-02-01T18:25:54Z","closed_at":null,"body":"Columns of type `money` are displayed empty (`null`) and warning appears:\r\n```\r\ncreate table public.price (name text,price money) ;\r\ninsert into public.price (name,price) values ('A',10);\r\n\r\nselect * from public.price ;\r\n```\r\nThe result set appears as\r\n```\r\nname |price |\r\n-----|------|\r\nA    |      |\r\n```\r\ntogether with the following warning:\r\n```\r\nSQL Error [22003]: Unzulässiger Wert für den Typ double : Fr. 10,00.\r\n\r\norg.jkiss.dbeaver.model.exec.DBCException: SQL Error [22003]: Unzulässiger Wert für den Typ double : Fr. 10,00.\r\n\tat org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCAbstractValueHandler.fetchValueObject(JDBCAbstractValueHandler.java:56)\r\n\tat org.jkiss.dbeaver.ui.controls.resultset.ResultSetDataReceiver.fetchRow(ResultSetDataReceiver.java:107)\r\n\tat org.jkiss.dbeaver.runtime.sql.SQLQueryJob.fetchQueryData(SQLQueryJob.java:603)\r\n\tat org.jkiss.dbeaver.runtime.sql.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:356)\r\n\tat org.jkiss.dbeaver.runtime.sql.SQLQueryJob.extractData(SQLQueryJob.java:708)\r\n\tat org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:1686)\r\n\tat org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:92)\r\n\tat org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:103)\r\n\tat org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)\r\nCaused by: org.postgresql.util.PSQLException: Unzulässiger Wert für den Typ double : Fr. 10,00.\r\n\tat org.postgresql.jdbc.PgResultSet.toDouble(PgResultSet.java:2922)\r\n\tat org.postgresql.jdbc.PgResultSet.getDouble(PgResultSet.java:2294)\r\n\tat org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCResultSetImpl.getDouble(JDBCResultSetImpl.java:396)\r\n\tat org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCNumberValueHandler.fetchColumnValue(JDBCNumberValueHandler.java:140)\r\n\tat org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCAbstractValueHandler.fetchValueObject(JDBCAbstractValueHandler.java:50)\r\n\t... 8 more\r\n```\r\n\r\nIn the command line I can see the price:\r\n```\r\n$ psql -c 'select * from public.price;'\r\n name |   price   \r\n------+-----------\r\n A    | Fr. 10,00\r\n(1 row)\r\n```"},"comment":{"url":"https://api.github.com/repos/serge-rider/dbeaver/issues/comments/276738525","html_url":"https://github.com/serge-rider/dbeaver/issues/1217#issuecomment-276738525","issue_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/1217","id":276738525,"user":{"login":"serge-rider","id":6398845,"avatar_url":"https://avatars.githubusercontent.com/u/6398845?v=3","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false},"created_at":"2017-02-01T18:25:54Z","updated_at":"2017-02-01T18:25:54Z","body":"This is PostgreSQL JDBC driver issue (https://github.com/pgjdbc/pgjdbc/issues/100). I can't fix it.\r\n\r\nWorkaround: \r\n```sql\r\nselect price::numeric from public.price ;\r\n```\r\n(I knows that this is a bad workaround but I don't know better solution for now)."}}
{"actor":{"display_login":"serge-rider"}}