On Fri, Nov 11, 2016 at 9:30 AM, Andreas Brandl <m...@andreas-brandl.de> wrote: > Hi, > > 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. > > 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'; > > After that I'd need to reflect the change on dependent objects like views as > well. > > Is this safe to do? Are there any unwanted consequences to this? > > This is still on 9.1 unfortunately - upgrade is going to follow soon after > this.
You just posted the same question a few days ago -- were the answers there unsatisfactory? merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
