Skip site navigation (1) Skip section navigation (2)

Re: NOT NULL

From: David Fetter <david(at)fetter(dot)org>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: NOT NULL
Date: 2003-10-30 03:55:02
Message-ID: 20031030035502.GJ10904@fetter.org (view raw or flat)
Thread:
Lists: sfpug
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

In response to

Responses

sfpug by date

Next:From: Josh BerkusDate: 2003-10-30 05:08:26
Subject: Re: NOT NULL
Previous:From: David WheelerDate: 2003-10-30 01:33:01
Subject: Re: NOT NULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group