Re: [GENERAL] resizing a varchar column on 8.3.8

2011-01-27 Thread Jon Hoffman
now 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 wrote: > > Hi, > > I was able to do this without any issues, though I don't have any views. > > - Jon > >

Re: [GENERAL] resizing a varchar column on 8.3.8

2011-01-27 Thread Jon Hoffman
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 wrote: > On 01/15/2011 04:22 PM, Jon Hoffman wrote: > >> Hi, >> >> I found a post with some instructions for resizing without locking up &g

[GENERAL] resizing a varchar column on 8.3.8

2011-01-15 Thread Jon Hoffman
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