Re: Modifying NOT NULL Constraint

From: "Dan Wilson" <dan_wilson(at)geocities(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Modifying NOT NULL Constraint
Date: 2000-06-14 06:17:32
Message-ID: 014a01bfd5c8$3ab0bd20$db7dfea9@dwilson
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

So if I'm understanding this correctly, this would be able to remove the NOT
NULL constraint, but would not be able to set the NOT NULL constraint. Is
that correct?

If that is correct, are their plans to implement a post-create setting of
the NOT NULL constraint?

-Dan

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dan Wilson" <phpPgAdmin(at)acucore(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Sent: Tuesday, June 13, 2000 10:33 PM
Subject: Re: [HACKERS] Modifying NOT NULL Constraint

> "Dan Wilson" <phpPgAdmin(at)acucore(dot)com> writes:
> > this was posed as a solutions to modifying the NOT NULL constraint:
> >> update pg_attributes set attnotnull = 'f' where oid =
oidofnotnullcolumn;
> >> vacuum analyze;
>
> attnotnull is where the gold is hidden, all right. The 'vacuum analyze'
> step is mere mumbo-jumbo --- there's no need for that.
>
> > Are there any side effects of which I should be aware before attempting
to
> > use this?
>
> Changing in that direction should be safe enough. Turning attnotnull
> *on* is a little more dubious, since it won't magically make any
> existing null entries in the column go away. attnotnull just governs
> the check that prevents you from storing new nulls.
>
> regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-06-14 06:31:07 Re: Modifying NOT NULL Constraint
Previous Message Bruce Momjian 2000-06-14 04:47:18 Re: Adding time to DATE type