| From: | Jeff Adams <jeff(dot)adams(at)noaa(dot)gov> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Updating pg_attribute to change field's data type from integer to bigint on very large table |
| Date: | 2012-04-13 15:30:11 |
| Message-ID: | CA+BdxK-=+AwW3k9d7U_sAQS0HnKY_ZyriunGikMP5L=U+BY=NA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
so i can? if so, how do i go about? i should mention that, while i dabble
in postgres dba activity, it is not my day job...
On Fri, Apr 13, 2012 at 11:27 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>
--
Jeffrey D. Adams
National Marine Fisheries Service
Office of Protected Resources
1315 East West Hwy, Building SSMC3
Silver Spring, MD 20910-3282
phone: (301) 427-8434
fax: (301) 713-0376
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bèrto ëd Sèra | 2012-04-13 16:05:34 | Re: Updating pg_attribute to change field's data type from integer to bigint on very large table |
| Previous Message | Tom Lane | 2012-04-13 15:27:28 | Re: Updating pg_attribute to change field's data type from integer to bigint on very large table |