Re: index keeps on growing

Okay, thanks for that information.  I will have to dig through my
pgsql-admin archive here and find the code for setting the primary key
flag. Unless of course someone would like to offer me the information
*HINT* :).  After I get the information, I will make the appropriate
changes to my script and place them up on the ftp server.

- brian


On Wed, 19 Jun 2002, Tom Lane wrote:

>
> Brian McCane <bmccane@mccons.net> writes:
> > The perl script will allow you to rebuild your indexes (indices?) without
> > having to kick out all of your users.  It reclaims all of the "holes" in
> > the index files.  It does NOT preserve the "primary key" setting for an
> > index, because as far as I can tell this doesn't actually make any
> > difference, primary keys are just an UNIQUE index.
>
> The primary-key marker does actually make a difference in just one case
> (AFAIK): when you create a foreign key reference from another table,
> the primary key serves to identify the default columns to reference.
> If you drop the marker then subsequent attempts to create referencing
> columns will have to explicitly identify the referenced columns.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

Wm. Brian McCane                    | Life is full of doors that won't open
Search http://recall.maxbaud.net/   | when you knock, equally spaced amid those
Usenet http://freenews.maxbaud.net/ | that open when you don't want them to.
Auction http://www.sellit-here.com/ | - Roger Zelazny "Blood of Amber"