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

Bug in DROP NOT NULL

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Bug in DROP NOT NULL
Date: 2005-03-31 09:06:06
Message-ID: 424BBD7E.8080808@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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.

Also, I dont think that ALTER TABLE blah CLUSTER ON foo; actually warns 
about clustering a non-null indexing index.  However, CLUSTER foo ON 
blah; does.

Chris

Responses

pgsql-hackers by date

Next:From: Teodor SigaevDate: 2005-03-31 10:46:43
Subject: Re: TSearch2 performance issue?
Previous:From: Mark KirkwoodDate: 2005-03-31 08:25:32
Subject: Re: [HACKERS] contrib/pg_buffercache

pgsql-patches by date

Next:From: Andrew DunstanDate: 2005-03-31 12:31:44
Subject: Re: [HACKERS] contrib/pg_buffercache
Previous:From: Mark KirkwoodDate: 2005-03-31 08:25:32
Subject: Re: [HACKERS] contrib/pg_buffercache

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