Hi,

PFA patch to fix the handling of  double precision[] type.
RM#1928

Steps to re-produce: Below given query fails to render result in Query tool,
SELECT ARRAY[1, 'nan', 3]::float[];

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
diff --git a/web/pgadmin/utils/driver/psycopg2/__init__.py 
b/web/pgadmin/utils/driver/psycopg2/__init__.py
index 502cee4..4f9ee68 100644
--- a/web/pgadmin/utils/driver/psycopg2/__init__.py
+++ b/web/pgadmin/utils/driver/psycopg2/__init__.py
@@ -62,10 +62,16 @@ psycopg2.extensions.register_type(
         (
             # To cast bytea and interval type
             17, 1186,
-            # to cast int4range, int8range, numrange tsrange, tstzrange, 
daterange
-            3904,3926, 3906, 3908, 3910, 3912, 3913,
+
+            # to cast int4range, int8range, numrange tsrange, tstzrange,
+            # daterange
+            3904, 3926, 3906, 3908, 3910, 3912, 3913,
+
             # date, timestamp, timestamptz, bigint, double precision, bigint[]
-            1700, 1082, 1114, 1184, 20, 701, 1016
+            1700, 1082, 1114, 1184, 20, 701, 1016,
+
+            # double precision[]
+            1022
          ),
         'TYPECAST_TO_STRING', psycopg2.STRING)
 )
-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

Reply via email to