See https://redmine.postgresql.org/issues/1713
On Tue, Sep 20, 2016 at 9:50 AM, Dave Page <dp...@pgadmin.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 <d...@phased.co.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 >>> d...@phased.co.uk >>> @citizenfishy >>> www.phased.co.uk >>> >>> On 19 Sep 2016, at 14:51, Murtuza Zabuawala < >>> murtuza.zabuaw...@enterprisedb.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 <d...@phased.co.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 >>>> d...@phased.co.uk >>>> @citizenfishy >>>> www.phased.co.uk >>>> >>>> On 19 Sep 2016, at 13:41, Murtuza Zabuawala < >>>> murtuza.zabuaw...@enterprisedb.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 <dp...@pgadmin.org> wrote: >>>> >>>>> OK, thanks. >>>>> >>>>> On Mon, Sep 19, 2016 at 1:06 PM, Murtuza Zabuawala >>>>> <murtuza.zabuaw...@enterprisedb.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 <dp...@pgadmin.org> >>>>> wrote: >>>>> >> >>>>> >> Murtuza, >>>>> >> >>>>> >> On Mon, Sep 19, 2016 at 12:22 PM, Dave Barter <d...@phased.co.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