Re: still lost: Cannot use more than 16 attributes in an index

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Bolden, Thomas" <tbolden(at)ded(dot)state(dot)mo(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: still lost: Cannot use more than 16 attributes in an index
Date: 2002-08-07 17:28:25
Message-ID: 200208071828.26468.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 07 Aug 2002 4:47 pm, Bolden, Thomas wrote:
> Then I use "make deinstall" to remove postgresql , renamed
> /usr/local/pgsql/data to data.old and rebooted.
> Changed to
> /usr/ports/databases/postgresql7 and used "make".
> Edited
> /usr/ports/databases/postgresql7/work/postgresql-7.2.1/src/includes/pg_conf
>i g.h.in
> then used "make install". Checked /usr/local/include/pg_config.h
> and it showed #define INDEX_MAX_KEYS 32.

Are you sure these steps are in the right order? Seems to me you want to edit
the value *before* you use make. Otherwise it'll compile in the old value,
then the new value will get copied over during the install - hence the
confusion.

- Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Bowlby 2002-08-07 17:33:44 datetime function
Previous Message Patrick Nelson 2002-08-07 17:15:43 Re: Importing blob