Postgres Pro
Downloads
Home   >   mailing lists

Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data - Mailing list pgsql-general

From Reid Thompson
Subject Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data
Date
Msg-id 1322674209.22846.31.camel@raker2.ateb.com
Whole thread Raw
In response to Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data  (Gregg Jaskiewicz <gryzman@gmail.com>)
Responses Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Tue, 2011-11-22 at 15:55 +0000, Gregg Jaskiewicz wrote:
> for the future it is better to just use text type, and: check
> length(field) < 35;

thanks to all for the respones.

The above seems a prudent way to go in my future.

My assumption is that converting varchar(n) to text would still force a
re-write of the table?  i.e. currently there's no officially 'safe' way
to convert the field type w/o incurring a table re-write.

pgsql-general by date:

Previous
From: Rodrigo Gonzalez
Date:
Subject: Re: Strange problem with turning WAL archiving on
Next
From: Tom Lane
Date:
Subject: Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data