[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] [GENERAL] Case sensitivity
From:       Dev Kumkar <devdas.kumkar () gmail ! com>
Date:       2013-12-13 7:20:42
Message-ID: CALSLE1MZ2n3BpYdGO0d=HsqDBEwdGNxc4KQJLRBJ0wK-yGm85Q () mail ! gmail ! com
[Download RAW message or body]

On Thu, Dec 12, 2013 at 12:47 PM, Dev Kumkar <devdas.kumkar@gmail.com>wrote:

> + hackers
>
>
>
> On Thu, Dec 12, 2013 at 12:34 PM, Dev Kumkar <devdas.kumkar@gmail.com>wrote:
>
>> On Wed, Dec 11, 2013 at 9:47 PM, Dev Kumkar <devdas.kumkar@gmail.com>wrote:
>>
>>> Actually for searches lower will work.
>>> But the other important aspect is 'inserts' which would result 2 rows if
>>> the values are 'A' and 'a'. Intent here to have it case insensitive.
>>>
>>> If CITEXT it will update the same row and works.
>>> CITEXT is an alternative but was wondering if there is any other
>>> alternate solution/setting while creating database.
>>>
>>> Also does CITEXT fetch via JDBC works the same way as fetch/set string
>>> values? Any quick comments here.
>>>
>>> http://techie-experience.blogspot.in/2013/04/hibernate-supporting-case-insensitive.html
>>>
>>> Regards...
>>>
>>
>> Also if the key columns are CITEXT is there any performance issues on
>> indexes?
>>
> I am ok with CITEXT but for changing the database design for the
primary/foreign key columns to be CITEXT need some suggestions/comments
regarding performance for inserts/reads.

Awaiting...

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Thu, Dec 12, 2013 \
at 12:47 PM, Dev Kumkar <span dir="ltr">&lt;<a href="mailto:devdas.kumkar@gmail.com" \
target="_blank">devdas.kumkar@gmail.com</a>&gt;</span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">+ hackers<div><div \
class="h5"><br><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On \
Thu, Dec 12, 2013 at 12:34 PM, Dev Kumkar <span dir="ltr">&lt;<a \
href="mailto:devdas.kumkar@gmail.com" \
target="_blank">devdas.kumkar@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div \
class="gmail_quote"><div>On Wed, Dec 11, 2013 at 9:47 PM, Dev Kumkar <span \
dir="ltr">&lt;<a href="mailto:devdas.kumkar@gmail.com" \
target="_blank">devdas.kumkar@gmail.com</a>&gt;</span> wrote:<br>


<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div><div><div>Actually for searches lower \
will work.<br></div>But the other important aspect is &#39;inserts&#39; which would \
result 2 rows if the values are &#39;A&#39; and &#39;a&#39;. Intent here to have it \
case insensitive.<br>



<br>If CITEXT it will update the same row and works.<br>CITEXT is an alternative but \
was wondering if there is any other alternate solution/setting while creating \
database.<br></div><br></div><div>Also does CITEXT fetch via JDBC works the same way \
as fetch/set string values? Any quick comments here.<br>



<a href="http://techie-experience.blogspot.in/2013/04/hibernate-supporting-case-insensitive.html" \
target="_blank">http://techie-experience.blogspot.in/2013/04/hibernate-supporting-case-insensitive.html</a><br></div><div>



</div><div><br></div>
Regards...<br></div></blockquote><div><br></div></div><div>Also if the key columns \
are CITEXT is there any performance issues on indexes? <br></div></div></div></div> \
</blockquote></div></div></div></div></div></div></div> </blockquote></div>I am ok \
with CITEXT but for changing the database design for the primary/foreign key columns \
to be CITEXT need some suggestions/comments regarding performance for \
inserts/reads.<br><br></div><div class="gmail_extra"> Awaiting...<br> 
</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]