Re: BUG #5633: an empty row with null-like values in not-null field

On Sun, Aug 29, 2010 at 8:10 PM, tkim <kth999@gmail.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05633
> Logged by: =A0 =A0 =A0 =A0 =A0tkim
> Email address: =A0 =A0 =A0kth999@gmail.com
> PostgreSQL version: 9.0 beta 4
> Operating system: =A0 windows 7 professional
> Description: =A0 =A0 =A0 =A0an empty row with null-like values in not-nul=
l field
> Details:
>
> After inserting a lot of data into a partitioned table, i found a weird
> thing. When I query the table, i can see an empty row with null-like valu=
es
> in 'not-null' fields.
>
> To show you guys the captured image, i think it's good to link my question
> on StackOverflow website.
>
> http://stackoverflow.com/questions/3597000/postgresql-9-0-an-empty-row-wi=
th-
> null-like-values-in-not-null-field

Can you send us the results of:

pg_dump -t st_daily2

and the results of doing this in psql:

\d st_daily2

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company