X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7A17153493 for ; Sun, 10 Apr 2005 21:15:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24878-03 for ; Mon, 11 Apr 2005 00:15:11 +0000 (GMT) Received: from box10.bluehost.com (box10.bluehost.com [67.138.240.10]) by svr1.postgresql.org (Postfix) with ESMTP id 6B0BE52952 for ; Sun, 10 Apr 2005 21:15:10 -0300 (ADT) Received: from theintra by box10.bluehost.com with local (Exim 4.43) id 1DKma6-0005mo-8A; Sun, 10 Apr 2005 18:15:10 -0600 Received: from 202.12.92.169 ([202.12.92.169]) (SquirrelMail authenticated user mps@theintraweb.net); by theintraweb.net with HTTP; Sun, 10 Apr 2005 18:15:10 -0600 (MDT) Message-ID: <49363.202.12.92.169.1113178510.squirrel@202.12.92.169> Date: Sun, 10 Apr 2005 18:15:10 -0600 (MDT) Subject: pg.py under Mac OS X From: mps@theintraweb.net To: pgsql-interfaces@postgresql.org Cc: mps@theintraweb.net User-Agent: SquirrelMail/1.4.3a X-Mailer: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - box10.bluehost.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [32226 740] / [47 12] X-AntiAbuse: Sender Address Domain - theintraweb.net X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200504/43 X-Sequence-Number: 5459 Hello Interfaces List, I am trying to get python access to postgresql-7.4.7 under Mac OS X 10.3.8. When I compiled postgresql from the source I used --with-python, but got the following error: *** Cannot build PL/Python because libpython is not a shared library. *** You might have to rebuild your Python installation. Refer to *** the documentation for details. I figured I'd simply install PyGreSQL instead. I installed postgresql and got it going then I dropped down the PyGreSQL-3.6.1 archive, untar'ed it and ran: python setup.py build but got the following error: gcc -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -fno-common -dynamic -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -I/usr/local/pgsql/include -I/usr/local/pgsql/include/server -I/System/Library/Frameworks/Python.framework/Versions/2.3/include/python2.3 -c pgmodule.c -o build/temp.darwin-7.8.0-Power_Macintosh-2.3/pgmodule.o pgmodule.c:31:22: postgres.h: No such file or directory pgmodule.c:34:29: catalog/pg_type.h: No such file or directory pgmodule.c: In function `get_type_array': pgmodule.c:300: error: `INT2OID' undeclared (first use in this function) pgmodule.c:300: error: (Each undeclared identifier is reported only once pgmodule.c:300: error: for each function it appears in.) pgmodule.c:301: error: `INT4OID' undeclared (first use in this function) pgmodule.c:305: error: `INT8OID' undeclared (first use in this function) pgmodule.c:306: error: `OIDOID' undeclared (first use in this function) pgmodule.c:310: error: `FLOAT4OID' undeclared (first use in this function) pgmodule.c:311: error: `FLOAT8OID' undeclared (first use in this function) pgmodule.c:312: error: `NUMERICOID' undeclared (first use in this function) pgmodule.c:316: error: `CASHOID' undeclared (first use in this function) error: command 'gcc' failed with exit status 1 After a quick search on my system, I find that postgres.h only exists in the postgresql-7.4.7 source directory, and was not installed with the headers in /usr/local/pgsql/include/ Is this correct? Should I be approaching this a different way? I am unsure of how to continue to get this going. Any help would be great, Cheers Matt Smith