Unknown values in int8 fields?

From: Chris Ruprecht <chrup999(at)yahoo(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Unknown values in int8 fields?
Date: 2001-07-16 02:05:43
Message-ID: B777B626.23D2%chrup999@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Chris,

When I load records with copy <table> 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Robby Slaughter 2001-07-16 02:24:15 RE: Unknown values in int8 fields?
Previous Message Tom Lane 2001-07-15 21:50:23 Re: Hey! ORDER BY in VIEWS?