3 Einträge, 1 Seite |
1
2
3
4
5
6
7
8
9
10
11
CREATE TABLE node (
id SERIAL NOT NULL PRIMARY KEY,
person_id INT NOT NULL REFERENCES person(id),
thread_id INT NOT NULL REFERENCES node(id),
parent_id INT REFERENCES node(id),
title VARCHAR(80),
text TEXT,
creation_time TIMESTAMP NOT NULL DEFAULT NOW(),
karma INT NOT NULL DEFAULT 0,
category_id INT NOT NULL REFERENCES category
);
1
2
3
DBD::Pg::st execute failed: ERROR: null value in column "thread_id" violates not-null constraint
insert() - DBD::Pg::st execute failed: ERROR: null value in column "thread_id" violates not-null constraint
at test.pl line 32
ERROR: cannot use column references in default expression
3 Einträge, 1 Seite |