filling an empty table w/ defaults defined - Mailing list pgsql-sql

From JT Kirkpatrick
Subject filling an empty table w/ defaults defined
Date
Msg-id 01BE90C6.9FF4D6A0.jt-kirkpatrick@mpsllc.com
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Christophe Labouisse
Date:
Subject: Re: [SQL] Strange behavior
Next
From: JT Kirkpatrick
Date:
Subject: incrementing by the second