From owner-freebsd-ports Wed Aug 7 9: 3: 2 2002 Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4FC1E37B407 for ; Wed, 7 Aug 2002 09:02:50 -0700 (PDT) Received: from services.state.mo.us (services.state.mo.us [168.166.2.67]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8564443E7B for ; Wed, 7 Aug 2002 09:02:49 -0700 (PDT) (envelope-from tbolden@ded.state.mo.us) Received: from wd01048 ([168.166.5.79]) by services.state.mo.us (8.11.6/8.11.6) with SMTP id g77G2iJ02714; Wed, 7 Aug 2002 11:02:45 -0500 (CDT) Message-ID: <000601c23e2d$1a44eb90$4f05a6a8@wd01048> Reply-To: "Thomas Bolden" From: "Thomas Bolden" To: Cc: Subject: FreeBSD Port: postgresql-7.2.1_1 Date: Wed, 7 Aug 2002 11:11:29 -0500 Organization: MO Dept of Eco Dev MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0003_01C23E03.2E0F8BF0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Sender: owner-freebsd-ports@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org This is a multi-part message in MIME format. ------=_NextPart_000_0003_01C23E03.2E0F8BF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am having trouble increasing the number of attributes allowed in a = primary key. 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=20 "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_co= nfi g.h.in then used "make install". Checked /usr/local/include/pg_config.h and it showed #define INDEX_MAX_KEYS 32. Ran "su -l pgsql -c initdb". Then edited /usr/local/etc/rc.d/010.pgsql.sh to include -o "-i" for = remote connection. executed /usr/local/etc/rc.d/010.pgsql.sh start "su pgsql" "createdb ALMIS". Then edited = /usr/local/pgsql/data/pg_hba.conf connected and ran sql statement to create the new table. still the same error. logged in locally , typed in the same statement and get the same error. Is there a problem with the FreeBSD port, any help would be appreciated Thomas Bolden=20 Department of Economic Development=20 GIS Programmer=20 tbolden@ded.state.mo.us=20 ------=_NextPart_000_0003_01C23E03.2E0F8BF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I am having trouble increasing the number of attributes allowed in a = primary=20 key.

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.

Ran "su -l pgsql -c initdb".

Then edited /usr/local/etc/rc.d/010.pgsql.sh to include -o "-i" for=20 remote

connection.

executed /usr/local/etc/rc.d/010.pgsql.sh start

"su pgsql" "createdb ALMIS". Then edited=20 /usr/local/pgsql/data/pg_hba.conf

connected and ran sql statement to create the new table. still the = same

error. logged in locally , typed in the same statement and get the = same

error.

Is there a problem with the FreeBSD port, any help would be = appreciated

Thomas Bolden

Department of Economic Development

GIS Programmer

tbolden@ded.state.mo.us=20

------=_NextPart_000_0003_01C23E03.2E0F8BF0-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-ports" in the body of the message