Re: Insert question null/not null serial, etc. - Mailing list pgsql-general

Russ Schneider <russ@sugapablo.com> writes:
> insert into nuke_referer values (NULL,'whatever');

> Which gives me the error: "Warning: pg_exec(): Query failed: ERROR:
> ExecAppend: Fail to add null value in not null attribute rid"

Sounds like they are expecting NULL to get replaced with the column
default, which is shall we say a rather surprising reading of the SQL
spec (and yeah, I know which other database acts that way).

> Since nowhere in the 3000 files of PHP-Nuke do they actually name columns
> for insert commands, does anyone have any suggestions?  Can NULL be
> replaced with anything?

In the last PG release or two you could write DEFAULT instead of NULL
and get the desired behavior.

            regards, tom lane