Re: Insert question null/not null serial, etc.

On Sat, Jan 31, 2004 at 04:56:58PM -0500, Russ Schneider wrote:

> 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"
>
> 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?

Try DEFAULT. It will work on some cases if the NULL value was intended
to insert the default value, but will of course fail otherwise.

I wonder how much confidence you do have on a "port to Postgres" that
doesn't even actually work. You'll probably have lots of more work to
do to make it run, let alone be efficient.

Also, hasn't PHP Nuke had lots of security problems? Somebody else may
be able to suggest a better alternative ...

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Find a bug in a program, and fix it, and the program will work today.
Show the program how to find and fix a bug, and the program
will work forever" (Oliver Silfridge)