Обсуждение: BUG #5633: an empty row with null-like values in not-null field

The following bug has been logged online:

Bug reference:      5633
Logged by:          tkim
Email address:      kth999@gmail.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

thnx.

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