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