Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have hooked-up PyCharm with my PostgreSQL database. All of my tables have a uuid column as their primary key. When I attempt to edit a row's value, I get the following error:

[2014-03-05 17:31:08] UPDATE "iv"."user" SET "active" = ? WHERE "id" = ?
[2014-03-05 17:31:08] [42883] ERROR: operator does not exist: uuid = character varying
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position: 49

When I edit a column value in a table with an integer primary key, the change saves properly, so I am sure it is an issue with the uuid primary key. Does anyone know how to get this to work? My co-worker is having this issue with IntelliJ Ultimate as well, so I'm assuming it is a problem with all IntelliJ products.

share|improve this question
It looks like this is a known bug on the JetBrains issue tracker. Almost a year old. – Tanner Mar 6 '14 at 19:45
up vote 1 down vote accepted

I emailed Gregory Shrago at JetBrains. He fixed the issue and it should be available in the latest Early Access Preview. The bug status is updated here:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.