Intellij 13 Ultimate: Unable to edit database rows with uuid primary keys in PostgreSQL

I recently set up my Intellij 13 Ultimate to connect to our PostgreSQL database.  It connects properly and I can view the tables.  However when I attempt to edit their values I get the following error:

12:04:02 PM UPDATE "<schema_name>"."user" SET "active" = ? WHERE "id" = ?
12:04:02 PM [42883] ERROR: operator does not exist: uuid = character varying
            No operator matches the given name and argument type(s). You might need to add explicit type casts.
            Position: 49

My co-worker tested it in PyCharm and received the same error.  Is there something I need to set in Intellij's Database tool to work with uuid values?  We don't have any issues when editing the values from pgAdmin.

While searching for a solution we came across this assigned bug from version 12 with no comments and no resolution:

http://youtrack.jetbrains.com/issue/IDEA-104501

Any assistance would be appreciated.

2 comments
Comment actions Permalink

Fixed. Thanks for pinging.

UUID edititing is allowed as plain text, i.e. no format checking for now.

0
Comment actions Permalink

Gregory,

Great!  Thank you for the fast response.  As soon as I get a chance I will download the 13.1 EAP and give it a try.

Just to clarify is the fixed added to Pycharm as well or will that need to be a separate update?

0

Please sign in to leave a comment.