Yes, I am aware of that, but the issue you mentioned is due to psycopg2 DictCursor issue which I have already mentioned earlier (RM#1409) https://github.com/psycopg/psycopg2/issues/454.
On Fri, Jul 15, 2016 at 4:37 PM, Dave Page <dpage@pgadmin.org> wrote:
On Thu, Jul 14, 2016 at 10:06 AM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote: > Hi, > > PFA patch to fix the issue where if user use cast function and it causes > freeze in query tool. > (RM#1438)
This fixes the hang, but then displays the wrong data type for the first column - e.g.
SELECT CURRENT_TIMESTAMP, CAST ( CURRENT_TIMESTAMP AS text ) ;
will show the columns as "now text(8)" and "now text", when it should be "now timestamp with time zone", "now text"
Note that SELECT CURRENT_TIMESTAMP also gets this a little wrong - it shows "now timestamp with time zone(8)" (the size shouldn't be included) -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake
