A person (cross) in the irc channel have found a bug with the new arrays.
Here is what I did to reproduce:
dennis=# CREATE TABLE foo (a int);
dennis=# INSERT INTO foo VALUES (ARRAY[2,NULL]);
INSERT 25353 1
That last insert contains a NULL value which are not allowed in arrays and
yet a insert is performed. The table contains a NULL value afterwards
(and no array).
This is something that should be fixed for 7.4.2, so that it gives an
error instead of inserting bad data.
pgsql-bugs by date
|Next:||From: Dennis Bjorklund||Date: 2004-01-15 13:02:46|
|Subject: Re: NULL in arrays|
|Previous:||From: Kris Jurka||Date: 2004-01-15 11:43:07|
|Subject: Re: ResultSet.getFetchSize()|