missing PostgreSQL headers

Hello,
i have some issues with psycopg. I am trying to configure a soft called
tinyerp-serv & tiny-client (tinyerp.org). These softs need psycopg. In fact, I
uncompressed and i compiled :
[root <at> localhost psycopg-1.0.15]#  ./configure
--with-postgres-libraries=/usr/include/pgsql
--with-mxdatetime-includes=DIR/egenix-mx-base-2.0.6/mx/DateTime/mxDateTime/
And the following error appeared unfortunatelly :
checking PostgreSQL version... configure: error: missing PostgreSQL headers
I use mandriva 2005 as OS. I installed postgresql with urpmi
Please could you help me

Re: missing PostgreSQL headers

On Sunday 07 Aug 2005 3:48 am, chandrasegaran@... wrote:
> Hello,
> i have some issues with psycopg. I am trying to configure a soft
> called tinyerp-serv & tiny-client (tinyerp.org). These softs need
> psycopg. In fact, I uncompressed and i compiled :
> [root <at> localhost psycopg-1.0.15]#  ./configure
> --with-postgres-libraries=/usr/include/pgsql
> --with-mxdatetime-includes=DIR/egenix-mx-base-2.0.6/mx/DateTime/mxD
>ateTime/ And the following error appeared unfortunatelly :
> checking PostgreSQL version... configure: error: missing PostgreSQL
> headers I use mandriva 2005 as OS. I installed postgresql with
> urpmi Please could you help me

you have to install the postgresql-devel package to get the headers. 
Also have to install egenix datetime from source to get those headers
--

-- 
regards
kg

http://www.livejournal.com/users/lawgon
tally ho! http://avsap.org.in
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!

Compile error "PyDateTimeAPI" defined but not used with 2.0beta4

Hello,

I've problems compiling latest beta in my i386 Debian server. Here is the output 
I get. I am using Python 2.4.1 and PostgreSql 8.0.3

-------------------------------------------------------------------------------
/usr/src # tar xfz psycopg2-2.0b4.tar.gz
/usr/src # cd psycopg2-2.0b4
/usr/src/psycopg2-2.0b4 # python setup.py build
running build
running build_py
creating build
creating build/lib.linux-i686-2.4
creating build/lib.linux-i686-2.4/psycopg2
copying lib/__init__.py -> build/lib.linux-i686-2.4/psycopg2
copying lib/extensions.py -> build/lib.linux-i686-2.4/psycopg2
copying lib/extras.py -> build/lib.linux-i686-2.4/psycopg2
copying lib/pool.py -> build/lib.linux-i686-2.4/psycopg2
copying lib/psycopg1.py -> build/lib.linux-i686-2.4/psycopg2
copying lib/tz.py -> build/lib.linux-i686-2.4/psycopg2
running build_ext
building 'psycopg2._psycopg' extension
creating build/temp.linux-i686-2.4
creating build/temp.linux-i686-2.4/psycopg
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes 
-fPIC -DPY_MAJOR_VERSION=2 -DPY_MINOR_VERSION=4 -DHAVE_PYBOOL=1 -DHAVE_DECIMAL=1 
-DHAVE_PYDATETIME=1 -DPSYCOPG_DEFAULT_PYDATETIME=1 -DPSYCOPG_VERSION="2.0b4 (dt 
ext pq3)" -DPSYCOPG_EXTENSIONS=1 -DPSYCOPG_DISPLAY_SIZE=1 -DHAVE_PQFREEMEM=1 
-DHAVE_PQPROTOCOL3=1 -I. -I/usr/include/postgresql/8.0 
-I/usr/include/postgresql/8.0/server -I/usr/local/hosting/include/python2.4 -c 

Re: Compile error "PyDateTimeAPI" defined but not used with 2.0beta4

Il giorno dom, 07/08/2005 alle 09.40 +0200, dharana ha scritto:
> Hello,
> 
> I've problems compiling latest beta in my i386 Debian server. Here is the output 
> I get. I am using Python 2.4.1 and PostgreSql 8.0.3

Have you installed libpq-dev?

--

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                fog@...
INIT.D Developer                                           fog@...
             I'm hung like Einstein and smart as a horse! -- Trottalemme

_______________________________________________
Psycopg mailing list
Psycopg@...
http://lists.initd.org/mailman/listinfo/psycopg

Re: Compile error "PyDateTimeAPI" defined but not used with 2.0beta4

Thank you Federico! I forgot I had to compile psycopg like this:

/usr/src/psycopg2-2.0b4 # CPPFLAGS=-I/usr/local/hosting/include \ 
LDFLAGS=-L/usr/local/hosting/lib python setup.py build

Is there any standard way of specifying headers and libraries in non-standard 
locations? Some python modules let you specify --with-someapp-includes=somedir

Or maybe it's worth to put a test in the build process that checks wether it can 
find postgresql sources or not?

Federico Di Gregorio wrote:
> Il giorno dom, 07/08/2005 alle 09.40 +0200, dharana ha scritto:
> 
>>Hello,
>>
>>I've problems compiling latest beta in my i386 Debian server. Here is the output 
>>I get. I am using Python 2.4.1 and PostgreSql 8.0.3
> 
> 
> Have you installed libpq-dev?
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Psycopg mailing list
> Psycopg@...
> http://lists.initd.org/mailman/listinfo/psycopg

Re: Compile error "PyDateTimeAPI" defined but not used with 2.0beta4

Il giorno dom, 07/08/2005 alle 11.08 +0200, dharana ha scritto:
> Thank you Federico! I forgot I had to compile psycopg like this:
> 
> /usr/src/psycopg2-2.0b4 # CPPFLAGS=-I/usr/local/hosting/include \ 
> LDFLAGS=-L/usr/local/hosting/lib python setup.py build
> 
> 
> Is there any standard way of specifying headers and libraries in non-standard 
> locations? Some python modules let you specify --with-someapp-includes=somedir
> 
> Or maybe it's worth to put a test in the build process that checks wether it can 
> find postgresql sources or not?

Just modify setup.cfg before building.

federico

--

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                fog@...
INIT.D Developer                                           fog@...
                              Viviamo in un mondo reale, Ciccio. -- Lucy

_______________________________________________
Psycopg mailing list
Psycopg@...
http://lists.initd.org/mailman/listinfo/psycopg

Re: Compiling psycopg 2.0 beta 3 on Solaris with Posgres 8

Il giorno mar, 05/07/2005 alle 09.05 -0400, Fox, Chuck (Civ, ARL/CISD)
ha scritto:
> Hi All,
>   I noticed that when I compiled the newest psycopg 2 beta on a Solaris v9 system 
> with postgres 8 that the library would fail to load with an symbol-relocation
> error for the 'round' function.  I went into the config.h file and noticed that 
> the ifdef for the round function is only active for FreeBSD and Windows.  After
> commenting out the ifdef the library loads fine on Solaris, so you may want to
> add Solaris (at least V9) to the ifdef list in config.h for the 'round' function.

Can somebody tell me what's the right preprocessor symbol to check for
Solaris? Many thanks.

federico

--

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                fog@...
INIT.D Developer                                           fog@...
  Alla faccia della trasparenza! Ma che si fa, lo si prende e lo si
   mena? (In pubblico, per trasparenza.)                     -- <mrjive>

_______________________________________________
Psycopg mailing list
Psycopg@...
http://lists.initd.org/mailman/listinfo/psycopg

Re: Compiling psycopg 2.0 beta 3 on Solaris with Posgres 8

On Sun, Aug 07, 2005 at 11:33:19AM +0200, Federico Di Gregorio wrote:
> Il giorno mar, 05/07/2005 alle 09.05 -0400, Fox, Chuck (Civ, ARL/CISD)
> ha scritto:
> >   I noticed that when I compiled the newest psycopg 2 beta on a Solaris v9 system 
> > with postgres 8 that the library would fail to load with an symbol-relocation
> > error for the 'round' function.  I went into the config.h file and noticed that 
> > the ifdef for the round function is only active for FreeBSD and Windows.  After
> > commenting out the ifdef the library loads fine on Solaris, so you may want to
> > add Solaris (at least V9) to the ifdef list in config.h for the 'round' function.
> 
> Can somebody tell me what's the right preprocessor symbol to check for
> Solaris? Many thanks.

__sun__ works for me on Solaris 9 with gcc 3.4.2.

--

-- 
Michael Fuhr

Listen/Notify Support?

I've been looking for information regarding support for Postgres's
Listen/Notify support in psycopg. The most I could gather was this
mailing list post from 2003:

    http://lists.initd.org/pipermail/psycopg/2003-July/002164.html

Has there been any further documentation of this? What's the status of
listen/notify in psycopg?

Thanks
Ken

Re: Listen/Notify Support?

Ken Kinder <ken@...> wrote:

> I've been looking for information regarding support for Postgres's
> Listen/Notify support in psycopg. The most I could gather was this

There's an example notify.py in the tar bar, and it works well here.

--

-- 
Dryice  <at>  http://dryice.3322.org

Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/sylvester-response.html

_______________________________________________
Psycopg mailing list
Psycopg@...
http://lists.initd.org/mailman/listinfo/psycopg