Online Lower Case Converter

I have the following table:

Customers---------name          textobject_id     integercreated_time  timestamp with time zone Indexes:    "my_index" UNIQUE CONSTRAINT, btree (name, object_id, created_time)

The unique index works fine but then I ended up with duplicate data like:

Name  |  object_id  |  created_time------------------------------------john  | 1           | 2018-02-28 15:42:14.30573+00JOHN  | 1           | 2018-02-28 15:42:14.30573+00

So I tried to lowercase all my data in the name column with:

UPDATE customers SET name=lower(name) WHERE name != LOWER(name);

But this procedure generated an error because now I would be violating the index:

ERROR:  duplicate key value violates unique constraint "my_index"DETAIL:  Key (name, object_id, created_time)=(john, 1, 2018-02-28 15:42:14.30573+00) already exists.

What kind of procedure could I use to delete rows that after casting to lowercase generate an index violation ?

Below is my string pattern,

'YES-HIDETotal Maze LLC.'

& I want to split the above string into below list,

 ['YES-HIDE', 'Total Maze LLC.']

How can I do this using regex in python?

Edit:

I'd like to split a string on a capital letter next to a capital letter followed by a lowercase letter using re package

To provide another example

'PLEASE SPLITThis String'

into

['PLEASE SPLIT', 'This String']

I wish to convert all the lowercase letters of a user given string to '#'. But upon running the code, only the last lowercase char is getting converted. Could someone suggest a solution to this ? (I am new in java)

import java.util.Scanner;class replaceEx{    public static void main(String args[])    {        Scanner s=new Scanner(System.in);        String s1,s2=null;        s1=s.nextLine();        for(int i=0;i<s1.length();i++)        {            if(s1.charAt(i)>='a' && s1.charAt(i)<='z')            s2=s1.replace(s1.charAt(i),'#');        }        System.out.println(s2);    }}

Input : ABCDabcd

Output: ABCDabc#

I'm working on this node.js code (just a sample below). The problem I'm facing is that in app.get I need to define the body.id as a lowerCase, simply because the system I'm working on would not accept a body.id with capitals letters in it.

In app.post I would like to retrieve the body.id for a connection to a specific url. But it will obviously return the lowercase id, which will redirect to an other url.

Is there a method that I can return form.id not as lowerCase in app.post? Caching perhaps?

app.get('/datasets', async function (req, res) {const formsResponse = await request({uri: 'https://test/forms',headers: {  'Authorization': token  },  json: true })let forms = formsResponse.items.map(form => {return {  id: form.id.toLowerCase(),  name: { en: title },  description: { en: 'description' },  columns: null }})app.post('/query', async function (req, res) {let formsAnswer = await request({uri: `https://test/forms/${req.body.id}`,headers: {  'Authorization': token  },json: true})

Is there a method that checks for these cases? Or do I need to parse each letter in the string, and check if it's lower case (letter) and is a number/letter?