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

Re: Patch to add support for partial indices

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Patch to add support for partial indices
Date: 2001-07-16 14:37:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
Patch applied by Tom.

> [Note to list maintainer: I sent this yesterday but it got stuck. I've
> resent it now. If you find it in the queue, you may safely delete it.]
> This patch re-enables support for partial indices. This includes:
> * Updates to documentation
> * Added pg_dump support
> * Corrections to the grammer to accept the CREATE statement
> * Update old broken code each index type
> * Fixes to VACUUM so that it handles indices in general better
> * Updates to the optimiser and cost estimators to handle them
> * Initial steps to removal of EXTEND INDEX statement
> * Patches the regression tests
> Note that Tom Lane has already taken the portion that deals with vacuum as
> part of his new vacuum code.
> As for the extend index statement, it was decided to remove it since it was
> not really flexible enough, so in general you'd be better off just dropping
> the index and recreating it.
> For further discussion, see the pgsql-general list. The patch against
> anonymous CVS as of a day ago or so.
> Many thanks to Tom Lane for tips and pointers during the initial revisions
> of this patch.
> -- 
> Martijn van Oosterhout <kleptog(at)svana(dot)org>
> > It would be nice if someone came up with a certification system that
> > actually separated those who can barely regurgitate what they crammed over
> > the last few weeks from those who command secret ninja networking powers.

[ Attachment, skipping... ]

> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-07-16 14:44:33
Subject: Re: Clear out the reminants of EXTEND INDEX
Previous:From: Tom LaneDate: 2001-07-16 14:36:40
Subject: Re: Patch to add support for partial indices

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