Re: Alter definition of a column - Mailing list pgsql-general

From Kelly Burkhart
Subject Re: Alter definition of a column
Date
Msg-id fa1e4ce70701192050v70f8cab0l34642471f4894ef0@mail.gmail.com
Whole thread Raw
In response to Re: Alter definition of a column  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Alter definition of a column  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-general
On 1/19/07, Martijn van Oosterhout <kleptog@svana.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

pgsql-general by date:

Previous
From: Ron Peterson
Date:
Subject: lanmanager and ntlm hash function contribution
Next
From: Bruno Wolff III
Date:
Subject: Re: Multiple column index usage question