{"action":"opened","issue":{"url":"https://api.github.com/repos/impossibl/pgjdbc-ng/issues/188","labels_url":"https://api.github.com/repos/impossibl/pgjdbc-ng/issues/188/labels{/name}","comments_url":"https://api.github.com/repos/impossibl/pgjdbc-ng/issues/188/comments","events_url":"https://api.github.com/repos/impossibl/pgjdbc-ng/issues/188/events","html_url":"https://github.com/impossibl/pgjdbc-ng/issues/188","id":92887899,"number":188,"title":"Add support for CITEXT type","user":{"login":"guylabs","id":1892848,"avatar_url":"https://avatars.githubusercontent.com/u/1892848?v=3","gravatar_id":"","url":"https://api.github.com/users/guylabs","html_url":"https://github.com/guylabs","followers_url":"https://api.github.com/users/guylabs/followers","following_url":"https://api.github.com/users/guylabs/following{/other_user}","gists_url":"https://api.github.com/users/guylabs/gists{/gist_id}","starred_url":"https://api.github.com/users/guylabs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/guylabs/subscriptions","organizations_url":"https://api.github.com/users/guylabs/orgs","repos_url":"https://api.github.com/users/guylabs/repos","events_url":"https://api.github.com/users/guylabs/events{/privacy}","received_events_url":"https://api.github.com/users/guylabs/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-07-03T14:38:05Z","updated_at":"2015-07-03T14:38:05Z","closed_at":null,"body":"Hi,\r\n\r\nI wanted to try this driver but unfortunately the `CITEXT` type is not supported. This is the exception I get when querying the database with a `CITEXT` type field:\r\n\r\n```\r\nCaused by: java.lang.IllegalStateException: type has no supported parameter format\r\n\tat com.impossibl.postgres.types.Type.getParameterFormat(Type.java:307)\r\n\tat com.impossibl.postgres.protocol.v30.ProtocolImpl.lengthOfParams(ProtocolImpl.java:723)\r\n\tat com.impossibl.postgres.protocol.v30.ProtocolImpl.writeBind(ProtocolImpl.java:508)\r\n\tat com.impossibl.postgres.protocol.v30.BindExecCommandImpl.execute(BindExecCommandImpl.java:319)\r\n\tat com.impossibl.postgres.protocol.v30.ProtocolImpl.execute(ProtocolImpl.java:370)\r\n\tat com.impossibl.postgres.jdbc.PGConnectionImpl.execute(PGConnectionImpl.java:434)\r\n\tat com.impossibl.postgres.jdbc.PGStatement.executeStatement(PGStatement.java:375)\r\n\tat com.impossibl.postgres.jdbc.PGPreparedStatement.execute(PGPreparedStatement.java:261)\r\n\tat com.impossibl.postgres.jdbc.PGPreparedStatement.executeQuery(PGPreparedStatement.java:277)\r\n\tat com.impossibl.postgres.jdbc.PGPreparedStatement.executeQuery(PGPreparedStatement.java:92)\r\n\tat com.zaxxer.hikari.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:52)\r\n\tat com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.executeQuery(PreparedStatementJavassistProxy.java)\r\n\tat org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)\r\n\tat org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)\r\n\tat org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)\r\n\tat org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:664)\r\n\tat org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:704)\r\n\tat org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:179)\r\n```\r\n\r\nIt would be nice when you could support the `CITEXT` type. It's nice that you took the opportunity to implement a new updated driver which supports the new features.\r\n\r\nThanks and regards,\r\n\r\nGuy "}}