Re: Updating pg_attribute to change field's data type from integer to bigint on very large table
| От | Jeff Adams |
|---|---|
| Тема | Re: Updating pg_attribute to change field's data type from integer to bigint on very large table |
| Дата | |
| Msg-id | CA+BdxK-=+AwW3k9d7U_sAQS0HnKY_ZyriunGikMP5L=U+BY=NA@mail.gmail.com обсуждение исходный текст |
| Ответ на | 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>) |
| Ответы |
Re: Updating pg_attribute to change field's data type from
integer to bigint on very large table
Re: Updating pg_attribute to change field's data type from integer to bigint on very large table |
| Список | 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...
--
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
On Fri, Apr 13, 2012 at 11:27 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
I wrote:Sheesh, hit send too quickly on that. Of course I meant "and so a
> 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.
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
В списке pgsql-general по дате отправления: