Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TYPE ... USING(NULL) / NOT NULL violation - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ALTER TYPE ... USING(NULL) / NOT NULL violation
Date
Msg-id 20370.1152021926@sss.pgh.pa.us
Whole thread Raw
In response to ALTER TYPE ... USING(NULL) / NOT NULL violation  ("Alexander M. Pravking" <fduch@antar.bryansk.ru>)
List pgsql-bugs
Tree view 
"Alexander M. Pravking" <fduch@antar.bryansk.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: query very slow when enable_seqscan=on
Next
From: Tomasz Ostrowski
Date:
Subject: Re: query very slow when enable_seqscan=on