Postgres Pro
Downloads
Home   >   mailing lists

Re: Updating pg_attribute to change field's data type from integer to bigint on very large table - Mailing list pgsql-general

From Tom Lane
Subject Re: Updating pg_attribute to change field's data type from integer to bigint on very large table
Date
Msg-id 24395.1334330848@sss.pgh.pa.us
Whole thread Raw
In response to Re: Updating pg_attribute to change field's data type from integer to bigint on very large table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Updating pg_attribute to change field's data type from integer to bigint on very large table  (Jeff Adams <jeff.adams@noaa.gov>)
List pgsql-general
Tree view 
I wrote:
> No, that is an actual on-disk change (making the field physically
> wider), so it's going to cost ya.  There are some cases where the
> on-disk representation doesn't change and so a catalog update isn't
> needed, but int4->int8 isn't one of them.

Sheesh, hit send too quickly on that.  Of course I meant "and so a
catalog update is all that's needed".

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Updating pg_attribute to change field's data type from integer to bigint on very large table
Next
From: Jeff Adams
Date:
Subject: Re: Updating pg_attribute to change field's data type from integer to bigint on very large table