Re: JSON

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(dot)zabuawala(at)enterprisedb(dot)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