Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Scott Marlowe <scott.marlowe@xxxxxxxxx>
Subject: 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@xxxxxxxxx>
Date: Tue, 22 Nov 2011 15:55:27 +0000
Cc: Reid Thompson <reid.thompson@xxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAOR=d=3uQta00FfWwxRUy2ek3rrm30e9SQMJ0KXrAiCP=ShZ8w@mail.gmail.com>

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

References:
- Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data
  - From: Reid Thompson
- Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data
  - From: Scott Marlowe

Prev by Date: Re: are there any methods to disable updating index before inserting large number tuples?
Next by Date: pg_standby for postgresql8.2
Previous by thread: Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data
Next by thread: Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]