Received: from smtp011.mail.yahoo.com (smtp011.mail.yahoo.com [216.136.173.31]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6G261a08993 for ; Sun, 15 Jul 2001 22:06:02 -0400 (EDT) (envelope-from chrup999@yahoo.com) Received: from chill-025.bbnow.net (HELO ?192.168.0.4?) (24.219.2.25) by smtp.mail.vip.sc5.yahoo.com with SMTP; 16 Jul 2001 02:05:55 -0000 X-Apparently-From: User-Agent: Microsoft-Entourage/9.0.1.3108 Date: Sun, 15 Jul 2001 21:05:43 -0500 Subject: Unknown values in int8 fields? From: Chris Ruprecht To: "pgsql-sql@postgresql.org" Message-ID: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Archive-Number: 200107/193 X-Sequence-Number: 3988 Hi Chris, When I load records with copy from ... And one of the fields (last one) is left empty, I want the default of nextval('sequence_table') to kick in - but it doesn't. Now, the field with a unique index on it stays blank. No big deal if I could go and say 'update rate set recno = nextval('sequence_rate') where recno = 0 - but it's not that easy as the recno is not 0 but - hmm what? What can I check for? I tried '?' and ? And 0 and ... And ... And ... But nothing works ... Now what? Best regards Chris _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com