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]  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.