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