[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Insert question null/not null serial, etc.
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2004-01-31 23:15:32
Message-ID: 8888.1075590932 () sss ! pgh ! pa ! us
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]