subject:"Re\: \[pgadmin\-support\] JSON"

Re: [pgadmin-support] JSON

2016-09-20 Thread Dave Page

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

On Tue, Sep 20, 2016 at 9:50 AM, Dave Page  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  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  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  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  wrote:

> 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 Zabuawala
> > EnterpriseDB: http://www.enterprisedb.com
> > The Enterprise PostgreSQL Company
> >
> > On Mon, Sep 19, 2016 at 5:19 PM, Dave Page 
> wrote:
> >>
> >> 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 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
>

 



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

Re: [pgadmin-support] JSON

2016-09-20 Thread Dave Page

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.zabuaw...@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  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  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  wrote:
>>>
 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 Zabuawala
 > EnterpriseDB: http://www.enterprisedb.com
 > The Enterprise PostgreSQL Company
 >
 > On Mon, Sep 19, 2016 at 5:19 PM, Dave Page  wrote:
 >>
 >> 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 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

>>>
>>> 
>>>
>>>
>>>
>>
>>
>


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

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

Re: [pgadmin-support] JSON

2016-09-20 Thread Murtuza Zabuawala

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

> 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...@phased.co.uk
> @citizenfishy
> www.phased.co.uk
>
> On 19 Sep 2016, at 14:51, Murtuza Zabuawala  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  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  wrote:
>>
>>> 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 Zabuawala
>>> > EnterpriseDB: http://www.enterprisedb.com
>>> > The Enterprise PostgreSQL Company
>>> >
>>> > On Mon, Sep 19, 2016 at 5:19 PM, Dave Page  wrote:
>>> >>
>>> >> 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 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
>>>
>>
>> 
>>
>>
>>
>
>

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:

> 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...@phased.co.uk
> @citizenfishy
> www.phased.co.uk
>
> On 19 Sep 2016, at 14:51, Murtuza Zabuawala  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  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  wrote:
>>
>>> 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 Zabuawala
>>> > EnterpriseDB: http://www.enterprisedb.com
>>> > The Enterprise PostgreSQL Company
>>> >
>>> > On Mon, Sep 19, 2016 at 5:19 PM, Dave Page  wrote:
>>> >>
>>> >> 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 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
>>>
>>
>> 
>>
>>
>>
>
>

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...@phased.co.uk
@citizenfishy
www.phased.co.uk

> On 19 Sep 2016, at 14:51, Murtuza Zabuawala 
>  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  > 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 
>> > > 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 > > wrote:
>> 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 Zabuawala
>> > EnterpriseDB: http://www.enterprisedb.com 
>> > The Enterprise PostgreSQL Company
>> >
>> > On Mon, Sep 19, 2016 at 5:19 PM, Dave Page > > > wrote:
>> >>
>> >> 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 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
>> 
>> 
> 
>

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

On Mon, Sep 19, 2016 at 6:26 PM, Dave Barter  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  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  wrote:
>
>> 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 Zabuawala
>> > EnterpriseDB: http://www.enterprisedb.com
>> > The Enterprise PostgreSQL Company
>> >
>> > On Mon, Sep 19, 2016 at 5:19 PM, Dave Page  wrote:
>> >>
>> >> 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 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
>>
>
> 
>
>
>

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 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 
>  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  > wrote:
> 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 Zabuawala
> > EnterpriseDB: http://www.enterprisedb.com 
> > The Enterprise PostgreSQL Company
> >
> > On Mon, Sep 19, 2016 at 5:19 PM, Dave Page  > > wrote:
> >>
> >> 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 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
> 
>

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 Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> On Mon, Sep 19, 2016 at 5:19 PM, Dave Page  wrote:
>>
>> 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 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


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

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 Mon, Sep 19, 2016 at 5:19 PM, Dave Page  wrote:

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

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


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] JSON

Re: [pgadmin-support] JSON

Re: [pgadmin-support] JSON

Re: [pgadmin-support] JSON

Re: [pgadmin-support] JSON

Re: [pgadmin-support] JSON

Re: [pgadmin-support] JSON

Re: [pgadmin-support] JSON

Re: [pgadmin-support] JSON

Re: [pgadmin-support] JSON

10 matches

Site Navigation

Mail list logo

Footer information