Warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "id" violates not-null constraint in /srv/web/es/imho/htdocs/cake/cake/libs/model/dbo/dbo_postgres.php on line 108
DEBUG = 2
Nr
Query
Error
Affected
Num. rows
Took (ms)
1
SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';
0
7
12
2
SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='posts' ORDER BY ordinal_position
0
7
32
3
SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='users' ORDER BY ordinal_position
0
8
23
4
SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='photos' ORDER BY ordinal_position
0
9
22
5
SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='collections' ORDER BY ordinal_position
0
7
23
6
SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position FROM information_schema.columns WHERE table_name ='comments' ORDER BY ordinal_position
0
7
23
7
INSERT INTO "posts" ("title","body","user_id","created","modified") VALUES ('Opinions matter','My everso favourite human - the opinionless zombie - blindly following the words of his ``leaders'''' - this... website - I deliberatly try to avoid the word blog will depict him. Mainly it''ll be me depicting him.
Note that most of these texts are a result of boredom or insanity.
So long and thanks for all the attention your plants and kids would have deserved better.
Igor
','1','2006-06-07 03:11:17','2006-06-07 03:11:17')
ERROR: null value in column "id" violates not-null constraint