From: | "Robby Slaughter" <webmaster(at)robbyslaughter(dot)com> |
---|---|
To: | "Chris Ruprecht" <chrup999(at)yahoo(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | RE: Unknown values in int8 fields? |
Date: | 2001-07-16 02:24:15 |
Message-ID: | EPEHLKLEHAHLONFOKNHNGENIDCAA.webmaster@robbyslaughter.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I've not been following this too closely but it sounds like you are
trying to COPY records from table A to table B, where the table B
also includes a serial value.
Here's an easy trick which I'm pretty sure will work: instead of
using COPY use SELECT INTO. It's much slower but I think it will
do the trick.
Good luck! HTH.
-Robby
-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Chris Ruprecht
Sent: Sunday, July 15, 2001 9:06 PM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Unknown values in int8 fields?
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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-07-16 03:48:32 | Re: Unknown values in int8 fields? |
Previous Message | Chris Ruprecht | 2001-07-16 02:05:43 | Unknown values in int8 fields? |