[SQL] Exception executing SQL update

I just restored a database using a different owner and database name. Upon starting the application, I'm getting the following error:

Exception executing SQL update <ALTER TABLE \"AO_9412A1_AOUSER\" ADD CONSTRAINT U_AO_9412A1_AOUSER_USERNAME UNIQUE (\"USERNAME\")>
org.postgresql.util.PSQLException: ERROR: could not create unique index "u_ao_9412a1_aouser_username"
Detail: Key ("USERNAME")=(8a48869174e61af50178d2469d490089) is duplicated


So, I assuming that '8a48869174e61af50178d2469d490089' is already in that table.

I do the following command

select * from "AO_9412A1_AOUSER" where 'USERNAME' = '8a48869174e61af50178d2469d490089';


And I get

(0 rows)

Any tips?

Continue reading...