| 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: | Whole Thread | Raw Message | 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
| 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? |