Date: Mon, 21 Jan 2019 21:39:15 -0500
From: Bruce Momjian <bruce@momjian.us>
To: berthuijgen@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: citext plugin is not working with java applications
Message-ID: <20190122023915.GA19230@momjian.us>
References: <154443728618.5058.5812326339362259751@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <154443728618.5058.5812326339362259751@wrigleys.postgresql.org>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk

On Mon, Dec 10, 2018 at 10:21:26AM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/10/citext.html
> Description:
> 
> The citext plugin does not work in combination with jdbc. Thus it does not
> work with Java applications. It does work in pgadmin because that is python.
> I am using the right schema, and setting the jdbc stringtype to unspecified
> makes no difference. 
> Because Java is the most used programming language, a big warning on the
> postgresql citext documentation
> (https://www.postgresql.org/docs/10/citext.html) is needed until this is
> fixed.
> Case insensitive text is standard on many databases, thus this may be a big
> obstacle when you want to migrate.

You have not explained what "does not work" means.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +