Re: NOT NULL

On Wed, Oct 29, 2003 at 05:33:01PM -0800, David Wheeler wrote:
> On Wednesday, October 29, 2003, at 05:27 PM, elein wrote:
>
> >Well, you'll run into problems if there are any nulls hanging
> >around int the column.
>
> Right, duh. But I can check for that.
>
> >What is the problem with alter table? Or are you not at that
> >version?
>
> I need to support back to 7.1, at least in theory. And besides, I
> don't think that alter table allows you to add NOT NULLs yet.

Works for me on 7.3.4, anyway :)

Do you have some way of checking what versions are in your installed
base? PostgreSQL is really great because when a version goes up, it's
for significant improvements :)

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 cell: +1 415 235 3778