Table Merge Successful, Primary Keys Missing

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Table Merge Successful, Primary Keys Missing
Date: 2006-06-26 18:47:23
Message-ID: 20060626184723.54652.qmail@web33302.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

i'm trying to merge two tables together.

i'm able to do it with...

select *
into t_temp_final
from t_temp_output
union
SELECT * FROM t_product
;

however, i lost all my primary key values in
t_temp_final

i can't create a pkey now b/c i have 1000 null values.

how can i get around this situation?

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2006-06-26 20:01:34 Re: Table Merge Successful, Primary Keys Missing
Previous Message Garcia, Joshua 2006-06-26 18:31:53 Variable array sizes with PQexecParams