Adminer

Bugs and Features item #3545899, was opened at 2012-07-19 08:01
Message generated for change (Settings changed) made by jakubvrana
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3545899&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: PostgreSQL
Group: 3.4.0
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Falko (zortopgun)
Assigned to: Jakub Vrána (jakubvrana)
Summary: Postgres and user_types (enumeration)

Initial Comment:
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.


----------------------------------------------------------------------

Comment By: Jakub Vrána (jakubvrana)
Date: 2012-07-21 09:51

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

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3545899&group_id=264133

Bugs and Features item #3560358, was opened at 2012-08-21 07:00
Message generated for change (Tracker Item Submitted) made by zortopgun
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3560358&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: PostgreSQL
Group: 3.5.1
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Falko (zortopgun)
Assigned to: Jakub Vrána (jakubvrana)
Summary:  Postgres and user_types (enumeration)

Initial Comment:
Addon to Bug-ID: 3545899 / Feature-Request

In Version 3.5.1 all data is listed correctly, but there is no differences between the different data types.

For example:
I have defined the type enum_y_n_ with two values ("y" and "n").
But adminer shows a text field where I can enter "John" or something else. Of course Postgres returns a error if the data is incorrect.
For MySQL only the valid values are listed (radio buttons). So why not use the same mechanism for postgres, too?



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3560358&group_id=264133