#265 Postgres and user_types (enumeration)

3.4.0
closed-fixed
Jakub Vrána
PostgreSQL (25)
5
2012-07-21
2012-07-19
Falko
No

If you want to edit a row in a postgres database which has user defined types you get this error:

ERROR: operator does not exist: integer * enum_y_n
LINE 1: ...ser_lastname", "user_rights", "user_department", 1*"user_loc...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

I have defined the type enum_y_n_ with two values ("y" and "n").

Column Type Comment
user_loginname character varying(20)
user_password character varying(50)
user_firstname character varying(20)
user_lastname character varying(20)
user_rights integer
user_department character varying(30)
user_locked enum_y_n [Y]

Adminer does not show any data from the row you want to edit.

Discussion

  • Jakub Vrána
    Jakub Vrána
    2012-07-21

    Thank you for the report, I've fixed it in Git. You can download the "Current development version" from http://www.adminer.org/#download

     
  • Jakub Vrána
    Jakub Vrána
    2012-07-21

    • status: open --> closed-fixed