Hi all,
According to documentation: https://www.postgresql.org/docs/current/static/functions-enum.html when I execute SELECT enum_range(null::rainbow) then output should look like this: {red,orange,yellow,green,blue,purple}
But in pgAdmin output looks like this: {{,r,e,d,,,o,r,a,n,g,e,,,y,e,l,l,o,w,,,g,r,e,e,n,,,b,l,u,e,,,p,u,r,p,l,e,}}. When you click on the field, popup window shows correct value. I’ve double checked it in psql, and output is correct. I think it could be considered as bug in pgAdmin
PgAdmin details:
Version 2.0
Python Version 2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:42:59) [MSC v.1500 32 bit (Intel)]
Flask Version 0.12.2
Application Mode Desktop
Pg Version: 10.1
Regardless this one, many thanks for your great job pgAdmin Team!
Best regards,
Bartosz Dmytrak