Re: alter column type - Mailing list pgsql-general

From Tom Lane
Subject Re: alter column type
Date
Msg-id 26382.1433533372@sss.pgh.pa.us
Whole thread Raw
In response to Re: alter column type  (Casey Deccio <casey@deccio.net>)
List pgsql-general
Casey Deccio <casey@deccio.net> writes:
> Being unfamiliar with the internals, what's the risk here?  If postgres
> thinks something is a bigint, but previously stored it as an int, does that
> mean it will try to extract data beyond the boundary of some of the (old)
> 32-bit values and potentially throw off offsets for other values?

Yes.  This *will* break your table, spectacularly.  The other person who
was opining that it would work has no understanding of the actual storage
layout.

            regards, tom lane


pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: [PERFORM] Re: Re: Query running slow for only one specific id. (Postgres 9.3) version
Next
From: John R Pierce
Date:
Subject: Re: alter column type