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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-10-30 05:08:26 | Re: NOT NULL |
Previous Message | David Wheeler | 2003-10-30 01:33:01 | Re: NOT NULL |