public inbox for [email protected]
help / color / mirror / Atom feedFrom: Murtuza Zabuawala <[email protected]>
To: Dave Page <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: PATCH: To fix the issue where cast function causes freeze (pgAdmin4)
Date: Fri, 15 Jul 2016 17:19:35 +0530
Message-ID: <CAKKotZS=9S9dg4yohn3PRS5-PBY+TarZd6DaKw5poDxsK2OjbQ@mail.gmail.com> (raw)
In-Reply-To: <CAKKotZTZfw2MtV93nD34grAFiT+0_fCsNFSBvYrKfZ0f225eeA@mail.gmail.com>
References: <CAKKotZS+kv3fQGF0iKneCq17ZQ5PeGAtK0UrE1zVTNtfy9c14Q@mail.gmail.com>
<CA+OCxowZ-UT5DDC-Dsbgp28e0vd8wLQTWoAH6ShVjK34OTFp+Q@mail.gmail.com>
<CAKKotZTZfw2MtV93nD34grAFiT+0_fCsNFSBvYrKfZ0f225eeA@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgadmin-hackers>
++ FYI,
If you provide alias, it'll give you proper result :)
SELECT CURRENT_TIMESTAMP as ts, CAST ( CURRENT_TIMESTAMP AS text ) as
ts_as_text;
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
On Fri, Jul 15, 2016 at 5:14 PM, Murtuza Zabuawala <
[email protected]> wrote:
> Hi Dave,
>
> 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.
>
> The patch is for different issue (RM#1438).
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> On Fri, Jul 15, 2016 at 4:37 PM, Dave Page <[email protected]> wrote:
>
>> On Thu, Jul 14, 2016 at 10:06 AM, Murtuza Zabuawala
>> <[email protected]> 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
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
view thread (7+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: PATCH: To fix the issue where cast function causes freeze (pgAdmin4)
In-Reply-To: <CAKKotZS=9S9dg4yohn3PRS5-PBY+TarZd6DaKw5poDxsK2OjbQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox