Обсуждение: filling an empty table w/ defaults defined

Поиск
Список
Период
Сортировка

filling an empty table w/ defaults defined

От
JT Kirkpatrick
Дата:
Is there a way to "turn off" a field (insertdt datetime primary key default 
text 'now') as I populate a table?  I have a populated table, and a mirror 
image of its structure except with the field shown above added.  I'd like 
to insert data into the new table from the old, but postgres is telling me 
it cannot insert a duplicate key into a unique index - I figure it is 
trying to use the same date/time value for 'now'.  is there any other way?

jt