Re: ALTER TYPE ... USING(NULL) / NOT NULL violation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alexander M(dot) Pravking" <fduch(at)antar(dot)bryansk(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ALTER TYPE ... USING(NULL) / NOT NULL violation
Date: 2006-07-04 14:05:26
Message-ID: 20370.1152021926@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Alexander M. Pravking" <fduch(at)antar(dot)bryansk(dot)ru> writes:
> If a column type is being changed with USING (NULL) clause,
> NOT NULL constraint seems not to be checked:

Hm, the code seems to have provisions to check "SET NOT NULL", but
it fails to check pre-existing NOT NULL attributes :-(

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomasz Ostrowski 2006-07-04 14:44:08 Re: query very slow when enable_seqscan=on
Previous Message Tom Lane 2006-07-04 13:56:29 Re: query very slow when enable_seqscan=on