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.

  • It looks like this is a known bug on the JetBrains issue tracker. Almost a year old.
    – Tanner
    Commented Mar 6, 2014 at 19:45

1 Answer 1


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: http://youtrack.jetbrains.com/issue/IDEA-104501


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .