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

From: Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Reid Thompson <reid(dot)thompson(at)ateb(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data
Date: 2011-11-22 15:55:27
Message-ID: CAJY59_hqOKc8_yof0cMGFrDGUQ0LbtOtWCXUTS1_TNgyZB60-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

for the future it is better to just use text type, and: check
length(field) < 35;

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2011-11-22 17:16:08 Re: synchronous replication + fsync=off?
Previous Message Andrew Sullivan 2011-11-22 15:52:07 Re: are there any methods to disable updating index before inserting large number tuples?