PostgreSQL - Can't edit ENUM type column

Note: please leave bug reports and feature requests on

PostgreSQL - Can't edit ENUM type column

Postby bnhunsaker » Fri Nov 06, 2015 7:35 pm

Looks like there is/was a similar problem in MySQL.

How to reproduce in PostgreSQL:
create type y_or_n as enum ('Y','N');
create table enum_test ( id serial, answer y_or_n );

Now try to edit or add a row in the enum_test table using the data tab for that table.
It should allow Y or N in the 'answer' column, but the following error is

DBCException: SQL Error [42804]: ERROR: column "answer" is of type y_or_n but expression is of type character varying
Hint: You will need to rewrite or cast the expression.
Position: 46
Posts: 1
Joined: Fri Nov 06, 2015 7:22 pm

Re: PostgreSQL - Can't edit ENUM type column

Postby Serge » Tue Nov 10, 2015 3:44 pm

Try 3.5.3.
Enum types support added. In UI it still looks like string editor.
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Return to Support

Who is online

Users browsing this forum: No registered users and 10 guests