Re: Alter definition of a column

From: "Kelly Burkhart" <kelly(dot)burkhart(at)gmail(dot)com>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, af300wsm(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Alter definition of a column
Date: 2007-01-20 04:50:38
Message-ID: fa1e4ce70701192050v70f8cab0l34642471f4894ef0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/19/07, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
>
> ALTER TABLE, to be correct, actually has to check the entire table to
> make sure it's ok. By doing it directly you're basically telling the DB
> it's OK.
>
> For making a varchar column longer it's safe though, and the easiest way.

Is it possible to use a similar method to change a varchar(n) to text
with no length constraint?

-K

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2007-01-20 05:12:08 Re: Multiple column index usage question
Previous Message Bruce Momjian 2007-01-20 04:32:30 Re: [GENERAL] Corrupt database?