Re: Using View Data Comes Up Empty Now

Trying to post to mailing list...

From: Jordan Brown
Sent: Monday, November 14, 2011 10:52 AM
To: 'Dave Page'
Subject: RE: [pgadmin-support] Using View Data Comes Up Empty Now

Hey Dave,

I can't believe I never tried that. I thought I had went through all those options...I guess not. Appreciate it!

It's working fine now.

-Jordan

-----Original Message-----
From: Dave Page [mailto:dpage(at)pgadmin(dot)org]
Sent: Monday, November 14, 2011 10:42 AM
To: Jordan Brown
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Using View Data Comes Up Empty Now

Hi

On Mon, Nov 14, 2011 at 4:29 PM, Jordan Brown

<jordan(dot)brown(at)rackspace(dot)com> wrote:

> Hello:

>

>

>

> The version of pgAdmin III I'm now using is 1.14.0. However, I was using

> 1.12.3, and the same problem occurred (this is where it started). Operating

> System is Windows 7 Enterprise Version 6.1 (Build 7600).

>

>

>

> Anyways, I'm using pgAdmin III client to access a Greenplum Database

> (version 4.1). For a long time (several months), I was able to view data for

> quick access using View Data (rather than issuing a SQL command if

> applicable). A few weeks ago, though, when I clicked on View Data, it comes

> up a blank screen, except for a toolbar and showing how many rows selected

> at the bottom (e.g., 100 rows, 500 rows, etc.). Not long after this issue

> began, the query window crashed pgAdmin when trying to access that. I was

> able to fix this bug/issue by deleting the folder in

> C:\Users\user\AppData\Roaming. I thought this was a related issue, but it

> appears not to fix the empty widow for 'View Data'. Another idea was

> suggested by Greenplum support which was to update to the new version of

> pgAdmin III, which is 1.14.0. He had seen other bugs with 1.12.3, although

> not this particular one. This did not help either. I uninstalled the program

> several times as well. Finally, just to clarify, if I write SQL to query any

> table, the data shows up fine. I find it nice, sometimes, to be able to use

> 'View Data'-that is why I ask.

Have you tried using View -> Default View to reset the window layout?

--

Dave Page

Blog: http://pgsnake.blogspot.com

Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com

The Enterprise PostgreSQL Company