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

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-10 22:12:55
Message-ID: 3468.1152569575@sss.pgh.pa.us (view raw or flat)
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:

I've committed patches for this.  Thanks for the report.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: William ZHANGDate: 2006-07-11 01:04:15
Subject: Re: BUG #2496: Troubles with fixed-point types (NUMERIC, DECIMAL,...)
Previous:From: Dirk Lutzeb├ĄckDate: 2006-07-10 13:28:13
Subject: Re: partial indexes not used on parameterized queries?

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