Thread: Inconsistent display of NULL and empty string values

Inconsistent display of NULL and empty string values

From
Arkadiusz Piekarz
Date:
Hello,
I have a usability problem with pgAdmin, namely it displays certain
values in different ways depending on a part of the application.
Here is a screenshot of the problem: http://i.imgur.com/xrEYt.jpg

NULL values are shown as <NULL> in the query editor, but as empty
cells in the data editor.
Empty strings are shown as empty cells in the query editor, but they
are double apostrophes in the data one.

This issue makes it hard to check data in the tables, because you
constantly have to remind yourself how the data is represented in each
view.

I'm working on pgAdmin III v1.16 x32 (installed with binary of
PostgreSQL 9.2.1), English language, on Windows 7 x64.

Regards,
Arkadiusz Piekarz



Re: Inconsistent display of NULL and empty string values

From
Raymond O'Donnell
Date:
On 08/10/2012 17:55, Arkadiusz Piekarz wrote:
> Hello,
> I have a usability problem with pgAdmin, namely it displays certain
> values in different ways depending on a part of the application.
> Here is a screenshot of the problem: http://i.imgur.com/xrEYt.jpg
> 
> NULL values are shown as <NULL> in the query editor, but as empty
> cells in the data editor.
> Empty strings are shown as empty cells in the query editor, but they
> are double apostrophes in the data one.
> 
> This issue makes it hard to check data in the tables, because you
> constantly have to remind yourself how the data is represented in each
> view.

+1 to the above - if it's possible, I'd also like to see consistency
across all of PgAdmin on the display of nulls in particular.

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie



Re: Inconsistent display of NULL and empty string values

From
Guillaume Lelarge
Date:
On Mon, 2012-10-08 at 18:03 +0100, Raymond O'Donnell wrote:
> On 08/10/2012 17:55, Arkadiusz Piekarz wrote:
> > Hello,
> > I have a usability problem with pgAdmin, namely it displays certain
> > values in different ways depending on a part of the application.
> > Here is a screenshot of the problem: http://i.imgur.com/xrEYt.jpg
> > 
> > NULL values are shown as <NULL> in the query editor, but as empty
> > cells in the data editor.
> > Empty strings are shown as empty cells in the query editor, but they
> > are double apostrophes in the data one.
> > 
> > This issue makes it hard to check data in the tables, because you
> > constantly have to remind yourself how the data is represented in each
> > view.
> 
> +1 to the above - if it's possible, I'd also like to see consistency
> across all of PgAdmin on the display of nulls in particular.
> 

Seems fair. I added a ticket to remember to work on this later.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com