Re: Upgrade questions

On 03/12/12 1:25 PM, Tim Uckun wrote:
> create a new bigint field.
> copy all the IDs to it.
> index it in the background
> at frequency of your choosing sync the id field to the new field to keep it up.
> at a time of your choosing set the default for the new field to be
> serial starting at max(id)
> drop the ID field
> rename the field to id

if there's other tables that have FK references to this table's ID, that
could be problematic.





--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast