Thread: INSERT with SELECT not working in pgAdmin
Hi guys, I'm trying to merge two tables to one with INSERT and SELECT commands: INSERT into c_transactions (timestamp) SELECT entrytimestamp from c_transactions INSERT into c_transactions (timestamp) SELECT exittimestamp from c_transactions But getting this error on execution (in pgAdmin): "ERROR: null value in column "id" violates not-null constraint SQL Status:23502" What I'm doing wrong or is there another possibility for table merging? I'm using postgres 8.3. Thanks.
Hey Stefan,
The sounds like you have a field "id" in you "c_transactions" without
default value (which usually should be nextval('some_sequence'::regclass).
Do you create a sequence for "c_transactions"."id" ?
--
Regards,
Dmitriy
The sounds like you have a field "id" in you "c_transactions" without
default value (which usually should be nextval('some_sequence'::regclass).
Do you create a sequence for "c_transactions"."id" ?
--
Regards,
Dmitriy
Ok I found the solution. I have to use the UPDATE command and not the INSERT: UPDATE c_transactions SET timestamp = entrytimestamp and than: UPDATE c_transactions SET timestamp = exittimestamp WHERE exittimestamp IS NOT NULL