Re: Update with a Repeating Sequence - Mailing list pgsql-general

Grzegorz Jas'kiewicz wrote:
>
> alter table foo add newid sequencial;
>
> alter table foo drop field_id;
>
> alter table foo rename newid to field_id;
>
I can't do that; I need to preserve the field_id values.