Thread: BUG: pgAdmin III View table with empty strings

BUG: pgAdmin III View table with empty strings

From

"Matej Rizman"

Date:

16 July 2003, 14:20:03

Version: 0.8.0 (Jul 14 2003), Win32 version

Steps:
1) create table with one varchar column
CREATE TABLE public.test
( a varchar(50) NOT NULL
) WITHOUT OIDS;

2) fill it with some empty strings
INSERT INTO test(a) VALUES('')

3) run pgAdmin III, select table and choose view data from popup menu

4) pgAdmin III shows two apostrophes ('') instead of empty strings.

Regards,
Matej Rizman

Re: BUG: pgAdmin III View table with empty strings

From

"Dave Page"

Date:

16 July 2003, 14:33:09


> -----Original Message-----
> From: Matej Rizman [mailto:matej.rizman@guest.arnes.si]
> Sent: 16 July 2003 00:34
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] BUG: pgAdmin III View table with
> empty strings
>
>
> Version: 0.8.0 (Jul 14 2003), Win32 version
>
> Steps:
> 1) create table with one varchar column
> CREATE TABLE public.test
> (
>   a varchar(50) NOT NULL
> ) WITHOUT OIDS;
>
> 2) fill it with some empty strings
> INSERT INTO test(a) VALUES('')
>
> 3) run pgAdmin III, select table and choose view data from popup menu
>
> 4) pgAdmin III shows two apostrophes ('') instead of empty strings.

Hi,

That is by design and is described in the new docs/en_US/editgrid.html
file. The two single quotes represents empty string, whereas an empty
box represents NULL.

Regards, Dave.

Re: BUG: pgAdmin III View table with empty strings

From

"Donald Fraser"

Date:

16 July 2003, 15:38:47

----- Original Message -----
From: "Dave Page" <dpage@vale-housing.co.uk>
To: "Matej Rizman" <matej.rizman@guest.arnes.si>;
<pgadmin-support@postgresql.org>
Sent: Wednesday, July 16, 2003 3:27 PM
Subject: Re: [pgadmin-support] BUG: pgAdmin III View table with empty strings




>> -----Original Message-----
>> From: Matej Rizman [mailto:matej.rizman@guest.arnes.si]
>> Sent: 16 July 2003 00:34
>> To: pgadmin-support@postgresql.org
>> Subject: [pgadmin-support] BUG: pgAdmin III View table with
>> empty strings
>>
>>
>> Version: 0.8.0 (Jul 14 2003), Win32 version
>>
>> Steps:
>> 1) create table with one varchar column
>> CREATE TABLE public.test
>> (
>>   a varchar(50) NOT NULL
>> ) WITHOUT OIDS;
>>
>> 2) fill it with some empty strings
>> INSERT INTO test(a) VALUES('')
>>
>> 3) run pgAdmin III, select table and choose view data from popup menu
>>
>> 4) pgAdmin III shows two apostrophes ('') instead of empty strings.

>Hi,
>
>That is by design and is described in the new docs/en_US/editgrid.html
>file. The two single quotes represents empty string, whereas an empty
>box represents NULL.

Might I add my 2 cents worth:
If you have a string type column with a value of lets say two or more spaces
e.g. '   '::text, you cannot see the difference between that and a column that
returns NULL.
May be in this day and age of GUIs, a different colour might help?

Regards
Donald Fraser.

Re: BUG: pgAdmin III View table with empty strings

From

Andreas Pflug

Date:

16 July 2003, 16:24:15

Donald Fraser wrote:

>----- Original Message -----
>From: "Dave Page" <dpage@vale-housing.co.uk>
>To: "Matej Rizman" <matej.rizman@guest.arnes.si>;
><pgadmin-support@postgresql.org>
>Sent: Wednesday, July 16, 2003 3:27 PM
>Subject: Re: [pgadmin-support] BUG: pgAdmin III View table with empty strings
>
>
>
>
>  
>
>>>-----Original Message-----
>>>From: Matej Rizman [mailto:matej.rizman@guest.arnes.si]
>>>Sent: 16 July 2003 00:34
>>>To: pgadmin-support@postgresql.org
>>>Subject: [pgadmin-support] BUG: pgAdmin III View table with
>>>empty strings
>>>
>>>
>>>Version: 0.8.0 (Jul 14 2003), Win32 version
>>>
>>>Steps:
>>>1) create table with one varchar column
>>>CREATE TABLE public.test
>>>(
>>>  a varchar(50) NOT NULL
>>>) WITHOUT OIDS;
>>>
>>>2) fill it with some empty strings
>>>INSERT INTO test(a) VALUES('')
>>>
>>>3) run pgAdmin III, select table and choose view data from popup menu
>>>
>>>4) pgAdmin III shows two apostrophes ('') instead of empty strings.
>>>      
>>>
>
>  
>
>>Hi,
>>
>>That is by design and is described in the new docs/en_US/editgrid.html
>>file. The two single quotes represents empty string, whereas an empty
>>box represents NULL.
>>    
>>
>
>Might I add my 2 cents worth:
>If you have a string type column with a value of lets say two or more spaces
>e.g. '   '::text, you cannot see the difference between that and a column that
>returns NULL.
>May be in this day and age of GUIs, a different colour might help?
>
>  
>
Yes, it's going on the wishlist for V2.

Regards,
Andreas