Andreas Brandl <m...@3.141592654.de> writes:
> we have a pretty big table with an integer-type primary key. I'm looking for
> the quickest way to change the column type to bigint to avoid hitting the
> integer limit. We're trying to avoid prolonged lock situations and full table
> rewrites.
You have no choice. Those types are different sizes so there is no way
to avoid a table rewrite.
> I know I can hack this with an UPDATE on pg_attribute:
> -- change id type to bigint
> update pg_attribute set atttypid=20 where attrelid=264782 and attname = 'id';
That WILL break your table.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
