Date: Wed, 7 Aug 2002 11:11:29 -0500 From: "Thomas Bolden" <tbolden@ded.state.mo.us> To: <girgen@partitur.se> Cc: <ports@FreeBSD.org> Subject: FreeBSD Port: postgresql-7.2.1_1 Message-ID: <000601c23e2d$1a44eb90$4f05a6a8@wd01048>
next in thread | raw e-mail | index | archive | help
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 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2><FONT size=3D2> <P>I am having trouble increasing the number of attributes allowed in a = primary=20 key.</P> <P>I edited /usr/local/include/pg_config.h (FreeBSD not linux) to</P> <P>#define INDEX_MAX_KEYS 32</P> <P>used initdb to create a new database cluster and I still get </P> <P>"ERROR: Cannot use more than 16 attributes in an index"</P> <P>Then I use "make deinstall" to remove postgresql , renamed</P> <P>/usr/local/pgsql/data to data.old and rebooted. Changed to</P> <P>/usr/ports/databases/postgresql7 and used "make". Edited</P> <P>/usr/ports/databases/postgresql7/work/postgresql-7.2.1/src/includes/pg= _confi</P> <P>g.h.in then used "make install". Checked = /usr/local/include/pg_config.h</P> <P>and it showed #define INDEX_MAX_KEYS 32.</P> <P>Ran "su -l pgsql -c initdb".</P> <P>Then edited /usr/local/etc/rc.d/010.pgsql.sh to include -o "-i" for=20 remote</P> <P>connection.</P> <P>executed /usr/local/etc/rc.d/010.pgsql.sh start</P> <P>"su pgsql" "createdb ALMIS". Then edited=20 /usr/local/pgsql/data/pg_hba.conf</P> <P> </P> <P>connected and ran sql statement to create the new table. still the = same</P> <P>error. logged in locally , typed in the same statement and get the = same</P> <P>error.</P> <P>Is there a problem with the FreeBSD port, any help would be = appreciated</P> <P></P> <P></P> <P>Thomas Bolden </P> <P>Department of Economic Development </P> <P>GIS Programmer </P> <P><A = href=3D"mailto:tbolden@ded.state.mo.us">tbolden@ded.state.mo.us</A>=20 </P></FONT></FONT></DIV></BODY></HTML> ------=_NextPart_000_0003_01C23E03.2E0F8BF0-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-ports" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?000601c23e2d$1a44eb90$4f05a6a8>