I'm trying to add a
sequence function to an already existing field. All the 4000 records for this
table currently have a value already in this field, but I'd like new ones to
just get the next value by default as opposed to users being forced to type
something. What I'd like to do is to reload this table and get the field to be
updated by the sequence on the reload. I thought that by dumping the table with
pg_dump and reloading with the generated datafile, this would happen, but the
sequence's last_value field didn't change. Apparently, the values contained in
the dump file won't update the sequence. Short of thoroughly massaging the
datafile generated by the dump and turning all those record lines into SQL
INSERT statements, is there any way to effectively update a field for an
existing record so that the field gets the value from the sequence? I
would normally just set minimum value to something greater than what
already in the table, but the manually keyed values are all over the place, and
I guess I'd really like to remove the gaps in the current
values.
--
John
