Skip site navigation (1) Skip section navigation (2)

Re: BUG: pgAdmin III View table with empty strings

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Matej Rizman" <matej(dot)rizman(at)guest(dot)arnes(dot)si>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: BUG: pgAdmin III View table with empty strings
Date: 2003-07-16 14:27:40
Message-ID: 03AF4E498C591348A42FC93DEA9661B844B309@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: Matej Rizman [mailto:matej(dot)rizman(at)guest(dot)arnes(dot)si] 
> Sent: 16 July 2003 00:34
> To: pgadmin-support(at)postgresql(dot)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.

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2003-07-16 14:33:59
Subject: Re: minor bug in pgAdmin3 when creating views
Previous:From: Fjeld, ShaunaDate: 2003-07-16 14:13:07
Subject: Database Migration Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group