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(at)gmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5633
> Logged by:          tkim
> Email address:      kth999(at)gmail(dot)com
> PostgreSQL version: 9.0 beta 4
> Operating system:   windows 7 professional
> Description:        an empty row with null-like values in not-null 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 values
> 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-with-
> 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

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