From: | Jon Hoffman <jon(at)foursquare(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | emilu(at)encs(dot)concordia(dot)ca, pgsql-general(at)postgresql(dot)org |
Subject: | Re: resizing a varchar column on 8.3.8 |
Date: | 2011-01-27 20:57:32 |
Message-ID: | AANLkTi=udnZBck_FiuKSc1xsLEE6S9rZZwRMHz7jtVci@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This was originally discussed on this list here:
http://postgresql.1045698.n5.nabble.com/Smartest-way-to-resize-a-column-td1915892.html
Tom Lane suggested doing the resize in a BEGIN block at least to verify that
"\d tablename" reflects the catalog update.
- Jon
On Thu, Jan 27, 2011 at 3:39 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:
> It's one of those "It's perfectly safe, as long as nothing goes wrong"
> types of things. It should work, but I'd certainly play on a test
> server first. And if something goes wrong in the right way, you might
> not even know it for a while. But generally, it's pretty common to do
> this one hackish thing with the catalogs.
>
> On Thu, Jan 27, 2011 at 1:25 PM, Jon Hoffman <jon(at)foursquare(dot)com> wrote:
> > Hi,
> > I was able to do this without any issues, though I don't have any views.
> > - Jon
> >
> > On Thu, Jan 27, 2011 at 9:52 AM, Emi Lu <emilu(at)encs(dot)concordia(dot)ca> wrote:
> >>
> >> On 01/15/2011 04:22 PM, Jon Hoffman wrote:
> >>>
> >>> Hi,
> >>>
> >>> I found a post with some instructions for resizing without locking up
> >>> the table, but would like to get some re-assurance that this is the
> best
> >>> way:
> >>>
> >>>
> >>>
> http://sniptools.com/databases/resize-a-column-in-a-postgresql-table-without-changing-data
> >>>
> >>> How does that affect data storage and future updates on existing rows?
> >>
> >> I did not see any feedbacks about this topic.
> >>
> >> I need confirmation that it is safe to do this! Personally, I feel that
> it
> >> is specially useful when there are many view dependencies. Update from
> data
> >> dictionary, all views will be updated automatically, right?
> >>
> >> Thanks a lot!
> >> --
> >> Lu Ying
> >
> >
>
>
>
> --
> To understand recursion, one must first understand recursion.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2011-01-27 20:57:53 | Re: Adding ddl audit trigger |
Previous Message | Lawrence Cohan | 2011-01-27 20:47:11 | Re: Adding ddl audit trigger |