[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: Can I add "NOT NULL" to PRISTINE table columns?

From: Julian Foad <julian.foad_at_wandisco.com>
Date: Thu, 02 Dec 2010 10:27:02 +0000

I (Julian Foad) wrote:
> > Julian Foad <julian.foad_at_wandisco.com> writes:
> >
> > > I imagine it should be possible to add 'NOT NULL' to these columns
> > > without performing a format bump or writing any upgrade code. Am I
> > > right?
>
> Hyrum Wright wrote:
> > If we're already enforcing it in the C code, I see no problem with
> > doing so in the sql schema. Additionally, I don't really see how you
> > could add the 'NOT NULL' clause in a format bump without doing table
> > duplication, which doesn't seem worth the trouble for something like
> > this.
>
> Right.
>
> Philip Martin wrote:
> > Existing working copies would not be upgraded, although I suppose the
> > client would work. Perhaps make it a format 99 step?
>
> The software won't see any difference except it will provide a sanity
> check when we're developing and modifying Subversion code and testing
> against new WCs. I don't think there is any need to upgrade existing
> development WCs in this respect.
>
> I'll mention it in a comment in the format 99 step, but don't think we
> need to write any SQL for it.

Committed r1041321.

- Julian
Received on 2010-12-02 11:27:45 CET

This is an archived mail posted to the Subversion Dev mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.