From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | "Bolden, Thomas" <tbolden(at)ded(dot)state(dot)mo(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: still lost: Cannot use more than 16 attributes in an |
Date: | 2002-08-07 16:00:40 |
Message-ID: | 3D514428.9030302@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bolden, Thomas wrote:
> Ok I edited /usr/local/include/pg_config.h (FreeBSD not linux) to
> #define INDEX_MAX_KEYS 32
>
> used initdb to create a new database cluster and I still get
>
> "ERROR: Cannot use more than 16 attributes in an index"
>
> 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_confi
> g.h.in then used "make install". Checked /usr/local/include/pg_config.h
> and it showed #define INDEX_MAX_KEYS 32.
I think you want something like:
Edit /path/to/postgresql-source/src/includes/pg_config.h.in:
#define INDEX_MAX_KEYS 32
Then:
/usr/local/etc/rc.d/010.pgsql.sh stop
cd /path/to/postgresql-source
./configure --your-configure-options
make all
make install
initdb -D /path/to/postgresql-data
/usr/local/etc/rc.d/010.pgsql.sh start
HTH,
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-08-07 16:50:15 | Re: still lost: Cannot use more than 16 attributes in an |
Previous Message | Richard Huxton | 2002-08-07 15:58:51 | Re: CREATE FUNCTION |