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
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
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
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
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
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
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
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:
>