[pgadmin-support] JSON

2016-09-19 Thread Dave Barter
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? Dave Barter d...@phased.co.uk @citi

Re: [pgadmin-support] JSON

2016-09-19 Thread Dave Page
Murtuza, On Mon, Sep 19, 2016 at 12:22 PM, Dave Barter 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

Re: [pgadmin-support] JSON

2016-09-19 Thread Murtuza Zabuawala
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

Re: [pgadmin-support] JSON

2016-09-19 Thread Dave Page
OK, thanks. On Mon, Sep 19, 2016 at 1:06 PM, Murtuza Zabuawala 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 Z

Re: [pgadmin-support] JSON

2016-09-19 Thread Dave Barter
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

Re: [pgadmin-support] JSON

2016-09-19 Thread Murtuza Zabuawala
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

Re: [pgadmin-support] JSON

2016-09-19 Thread Dave Barter
I’ve recreated it again See attached screenshot For info the JSON for id 6343 is [{"name":"people_and_property","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...@p

Re: [pgadmin-support] JSON

2016-09-19 Thread Murtuza Zabuawala
Hi Dave, What is the array datatype for that particular column in which you are getting `[object Object]`, Is it json[ ] or jsonb[ ]? -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Mon, Sep 19, 2016 at 8:22 PM, Dave Barter wrote: >