From: | "Eft, Aaron" <Aaron(dot)Eft(at)avnet(dot)com> |
---|---|
To: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Alter Table Serial |
Date: | 2002-08-26 19:30:24 |
Message-ID: | D5261D5A4D81D51188B3000255FC111204B78887@amer31.avnet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Wondering if this is possible:
I'm trying to add a column to an existing database. This column would be
autoincrementing in the form of "bigserial". Now, since there are already
70,000 records in the database, I'd also like to have this assign a serial
number to those too, but understand if this is not possible. So far,
everything I've tried has come up with the message:
NOTICE: ALTER TABLE will create implicit sequence 'shipper_serial_seq' for
SERIAL column 'shipper.serial'
NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index
'shipper_serial_key' for table 'shipper'
ERROR: Adding columns with defaults is not implemented.
Add the column, then use ALTER TABLE SET DEFAULT.
I'm still very new to this, so any help is greatly appreciated.
Thanks!
--= Aaron Eft =--
60 S McKemy
Chandler, AZ 85226
(480) 961-6407
From | Date | Subject | |
---|---|---|---|
Next Message | Andrei Popovici | 2002-08-26 19:39:52 | Re: functions |
Previous Message | Josh Berkus | 2002-08-26 17:22:13 | Re: functions |