Re: Inserts with incomplete rows... NOT NULL constraints

Lars Erik Thorsplass wrote:
> The problem am now facing is that postgres will try to insert a NULL
> value for fields not specified in the insert query and that are
> defined as NOT NULL in the table structure. Is this the correct
> behaviour?

Actually, what it's doing is inserting the DEFAULT value for the field 
in question. If you don't specify a DEFAULT, it assumes null.

# CREATE TABLE test_tbl (a integer, b text DEFAULT 'bbb', c text);
# INSERT INTO test_tbl (a) VALUES (1);
# SELECT * FROM test_tbl; a |  b  | c
---+-----+--- 1 | bbb |

If you specify NOT NULL and don't want to provide a value you'll need to 
set a DEFAULT.

--   Richard Huxton  Archonet Ltd