Re: changing varchar limits - Mailing list pgsql-general

From Tom Lane
Subject Re: changing varchar limits
Date
Msg-id 28772.1028329619@sss.pgh.pa.us
Whole thread Raw
In response to Re: changing varchar limits  (Kevin Brannen <kevinb@nurseamerica.net>)
List pgsql-general
Kevin Brannen <kevinb@nurseamerica.net> writes:
> To easily change a column from nullable to not-nullable, is flipping the
> proper attribute all that's required?  Just asking, cause it would be
> very useful until there's an ALTER TABLE equivalent (in 7.3?).

Sure, just flip the bit (though if you're going to the not-nullable
state, it's your responsibility to make sure the existing data is in
fact not null).  This is basically what the 7.3 implementation does.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Creating GiST Indices?
Next
From: Arguile
Date:
Subject: Re: Postgres and Perl: Which DBI module?