Re: JSON

See https://redmine.postgresql.org/issues/1713

On Tue, Sep 20, 2016 at 9:50 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Hi Murtuza,
>
> FYI, I also see the same symptoms if I use EXPLAIN or EXPLAIN ANALYZE from
> the execute menu - and more importantly, the graphical query plan is not
> rendered.
>
> On Tue, Sep 20, 2016 at 8:05 AM, Murtuza Zabuawala <murtuza.zabuawala@
> enterprisedb.com> wrote:
>
>> I'm able to re-produce the issue now, I'll send patch for the same.
>>
>> Thanks for reporting.
>> Re-opening the issue: https://redmine.postgresql.org/issues/1404
>>
>>
>>
>> --
>> Regards,
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>> On Mon, Sep 19, 2016 at 8:22 PM, Dave Barter <dave(at)phased(dot)co(dot)uk> wrote:
>>
>>> I’ve recreated it again
>>>
>>> See attached screenshot
>>>
>>>
>>>
>>> For info the JSON for id 6343 is [{"name":"people_and_proper
>>> ty","app_id":37}]
>>>
>>> Field 8256 is [“whole..”,”.. ….]
>>>
>>> I have conformed the issue exists with another field that is of type [{
>>> …}]
>>>
>>> It appears to be an issue with arrays
>>>
>>> Dave Barter
>>> dave(at)phased(dot)co(dot)uk
>>> @citizenfishy
>>> www.phased.co.uk
>>>
>>> On 19 Sep 2016, at 14:51, Murtuza Zabuawala <
>>> murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>>>
>>> Hi,
>>>
>>> I tried many times opening/closing grid with table definition & sample
>>> data given by Dave but without inherits option but no luck in re-producing
>>> the issue on my side.
>>>
>>> Regards,
>>> Murtuza
>>>
>>> --
>>> Regards,
>>> Murtuza Zabuawala
>>> EnterpriseDB: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>> On Mon, Sep 19, 2016 at 6:26 PM, Dave Barter <dave(at)phased(dot)co(dot)uk> wrote:
>>>
>>>> Interestingly shutting down and restarting PGAdmin and the issue has
>>>> gone away. I will try and recreate again.
>>>>
>>>> If it makes a difference the table was inherited
>>>>
>>>> CREATE TABLE ng_customer.files
>>>> (
>>>> file_id integer,
>>>> file_name text,
>>>> file_path text,
>>>> file_attributes json,
>>>> record_count integer,
>>>> status character,
>>>> date_uploaded timestamp without time zone,
>>>> CONSTRAINT files_pkey PRIMARY KEY (file_id)
>>>> )
>>>> INHERITS (ng_toplevel.files)
>>>> WITH (
>>>> OIDS = FALSE
>>>> )
>>>>
>>>>
>>>> Dave Barter
>>>> dave(at)phased(dot)co(dot)uk
>>>> @citizenfishy
>>>> www.phased.co.uk
>>>>
>>>> On 19 Sep 2016, at 13:41, Murtuza Zabuawala <
>>>> murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>>>>
>>>> Hi Dave,
>>>>
>>>> I am able to see the json data properly in with *pgadmin4-1.0-rc1.dmg* file
>>>> on my mac machine,
>>>> Please find screenshot attached.
>>>>
>>>>
>>>> @Dave Barter,
>>>> Could you please share screenshot or your table definition, so that I
>>>> can re-produce the issue?
>>>>
>>>>
>>>> Regards,
>>>> Murtuza
>>>>
>>>> --
>>>> Regards,
>>>> Murtuza Zabuawala
>>>> EnterpriseDB: http://www.enterprisedb.com
>>>> The Enterprise PostgreSQL Company
>>>>
>>>> On Mon, Sep 19, 2016 at 5:37 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>
>>>>> OK, thanks.
>>>>>
>>>>> On Mon, Sep 19, 2016 at 1:06 PM, Murtuza Zabuawala
>>>>> <murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>>>>> > Hi Dave,
>>>>> >
>>>>> > I was aware of that issue and that's why I also tested SlickGrid JSON
>>>>> > support(in browsers) when I integrated it :)
>>>>> > Seems like issue with runtime's webkit, let me check & confirm.
>>>>> >
>>>>> > --
>>>>> > Regards,
>>>>> > Murtuza Zabuawala
>>>>> > EnterpriseDB: http://www.enterprisedb.com
>>>>> > The Enterprise PostgreSQL Company
>>>>> >
>>>>> > On Mon, Sep 19, 2016 at 5:19 PM, Dave Page <dpage(at)pgadmin(dot)org>
>>>>> wrote:
>>>>> >>
>>>>> >> Murtuza,
>>>>> >>
>>>>> >> On Mon, Sep 19, 2016 at 12:22 PM, Dave Barter <dave(at)phased(dot)co(dot)uk>
>>>>> wrote:
>>>>> >> > Apologies if I have missed this elsewhere
>>>>> >> >
>>>>> >> > JSON columns in tables are appearing as [Object object] when
>>>>> viewing
>>>>> >> > data so you cannot edit or view json as you used to be able to
>>>>> do in
>>>>> >> > pagadmin3
>>>>> >> >
>>>>> >> > I am using pgadmin 4 1.0-rc1 on Mac OSX
>>>>> >> >
>>>>> >> > Is this by design or a bug?
>>>>> >>
>>>>> >> Is this a regression following https://redmine.postgresql.org
>>>>> /issues/1404?
>>>>> >>
>>>>> >> --
>>>>> >> Dave Page
>>>>> >> Blog: http://pgsnake.blogspot.com
>>>>> >> Twitter: @pgsnake
>>>>> >>
>>>>> >> EnterpriseDB UK: http://www.enterprisedb.com
>>>>> >> The Enterprise PostgreSQL Company
>>>>> >
>>>>> >
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Dave Page
>>>>> Blog: http://pgsnake.blogspot.com
>>>>> Twitter: @pgsnake
>>>>>
>>>>> EnterpriseDB UK: http://www.enterprisedb.com
>>>>> The Enterprise PostgreSQL Company
>>>>>
>>>>
>>>> <JSON_data-min.jpg>
>>>>
>>>>
>>>>
>>>
>>>
>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company