Re: changing varchar limits

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Brannen <kevinb(at)nurseamerica(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: changing varchar limits
Date: 2002-08-02 23:06:59
Message-ID: 28772.1028329619@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kevin Brannen <kevinb(at)nurseamerica(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Arguile 2002-08-02 23:23:31 Re: Postgres and Perl: Which DBI module?
Previous Message Tom Lane 2002-08-02 23:02:02 Re: Creating GiST Indices?