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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
