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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
