Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.1) with ESMTP id PAA49214 for ; Tue, 27 Apr 1999 15:55:04 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id PAA28916 for ; Tue, 27 Apr 1999 15:54:32 -0400 Received: by localhost with Microsoft MAPI; Tue, 27 Apr 1999 15:57:17 -0400 Message-ID: <01BE90C6.9FF4D6A0.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-sql@hub.org'" Subject: filling an empty table w/ defaults defined Date: Tue, 27 Apr 1999 15:57:14 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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