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
What I'm doing wrong or is there another possibility for table merging?
I'm using postgres 8.3.
pgsql-general by date
|Next:||From: Aram Fingal||Date: 2010-09-20 19:20:59|
|Subject: Re: Installing Contrib Modules with a Precompiled Binary|
|Previous:||From: Colin 't Hart||Date: 2010-09-20 19:18:09|
|Subject: Re: to_date conversion semantics?|