Re: [GENERAL] resizing a varchar column on 8.3.8

2011-01-28 Thread Jasen Betts
On 2011-01-27, 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 >> 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

Re: [GENERAL] resizing a varchar column on 8.3.8

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

Re: [GENERAL] resizing a varchar column on 8.3.8

2011-01-27 Thread Scott Marlowe
On Thu, Jan 27, 2011 at 1:57 PM, Jon Hoffman wrote: > 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 t

Re: [GENERAL] resizing a varchar column on 8.3.8

2011-01-27 Thread Scott Marlowe
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 th

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 >> the table, but would like to ge

Re: [GENERAL] resizing a varchar column on 8.3.8

2011-01-27 Thread Emi Lu
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

[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