On 09/30/11 1:23 AM, John R Pierce wrote:
> convert the fields to bigint which are 64 bit and not likely to wrap
> around any time in this century
indeed, this is as simple as ...
alter table tblname alter column id type bigint;
of course, you'll need to alter all the FK fields that refer to it too,
and I don't know if that entangles this.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast