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

Re: Bug in DROP NOT NULL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in DROP NOT NULL
Date: 2005-03-31 14:59:55
Message-ID: 5419.1112281195@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> You can drop a NOT NULL on a column, even if that column is part of an 
>> index that is clustered, where the index does not index NULLs.

I don't think that's a bug.  You may not intend ever to cluster on that
index again, and if you try it will tell you about the problem.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Teodor SigaevDate: 2005-03-31 16:02:19
Subject: Re: TSearch2 performance issue?
Previous:From: Alvaro HerreraDate: 2005-03-31 14:45:36
Subject: Re: Understanding pg_xlog

pgsql-patches by date

Next:From: Michael FuhrDate: 2005-03-31 18:15:40
Subject: Re: HEAD \df doesn't show functions with no arguments
Previous:From: Christopher Kings-LynneDate: 2005-03-31 12:53:53
Subject: Re: Bug in DROP NOT NULL

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