pypgsql-users

[Pypgsql-users] setup on SuSE 7.3

[Oliver V. <vec...@ao...>]

Hi,

I'm trying to install pypgsql-2.0.tar.gz on a SuSE 7.3 Linux box. I 
started my build with:

python setup.py build

and got following error:

gcc: unrecognized option `-R/usr/local/pgsql/lib'

I use following version of gcc:
Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)


What am I doing wrong?

Regards,
Oliver

Re: [Pypgsql-users] setup on SuSE 7.3

[Gerhard <ger...@gm...>]

Le 18/02/02 ? 09:52, Oliver Vecernik écrivit:
> Hi,
> 
> I'm trying to install pypgsql-2.0.tar.gz on a SuSE 7.3 Linux box. I 
> started my build with:
> 
> python setup.py build
> 
> and got following error:
> 
> gcc: unrecognized option `-R/usr/local/pgsql/lib'

This is a warning, not an error.

Btw. SuSE installs PostgreSQL somewhere else, not /usr/local/pgsql. But
maybe you've installed PostgreSQL from a different source or compiled it
yourself. To use pyPgSQL with SuSE's PostgreSQL RPMs, you'd need to
change the paths in setup.py.

> I use following version of gcc:
> Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
> gcc version 2.95.3 20010315 (SuSE)
> 
> 
> What am I doing wrong?

Nothing. This is a gcc bug for which there's an (ugly) workaround in the
latest Python CVS (post 2.2), btw. If you've really installed PostgreSQL
in that directory, you can point LD_LIBRARY_PATH to the directory, or
add it to your file /etc/ld.so.conf.

Gerhard
-- 
mail:   gerhard <at> bigfoot <dot> de       registered Linux user #64239
web:    http://www.cs.fhm.edu/~ifw00065/    OpenPGP public key id 86AB43C0
public key fingerprint: DEC1 1D02 5743 1159 CD20  A4B6 7B22 6575 86AB 43C0
reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))

Re: [Pypgsql-users] setup on SuSE 7.3

[Oliver V. <vec...@ao...>]

Gerhard H=E4ring wrote:

Thank you for your immediate reply!

> Le 18/02/02 ? 09:52, Oliver Vecernik =E9crivit:
>=20
>>Hi,
>>
>>I'm trying to install pypgsql-2.0.tar.gz on a SuSE 7.3 Linux box. I=20
>>started my build with:
>>
>>python setup.py build
>>
>>and got following error:
>>
>>gcc: unrecognized option `-R/usr/local/pgsql/lib'
>>
>=20
> This is a warning, not an error.
>=20
> Btw. SuSE installs PostgreSQL somewhere else, not /usr/local/pgsql. But=

> maybe you've installed PostgreSQL from a different source or compiled i=
t
> yourself. To use pyPgSQL with SuSE's PostgreSQL RPMs, you'd need to
> change the paths in setup.py.


You're absolutely right. I compiled 7.1.3 myself. Meanwhile I installed=20
the driver and ran the tests.

=2E..........................EF......................
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
ERROR: CheckWeakReference1 (__main__.PgSQLTestCases)
----------------------------------------------------------------------
Traceback (most recent call last):
   File "test/PgSQLTestCases.py", line 333, in CheckWeakReference1
     self.assertEquals(len(self.cnx.cursors.data.keys()), 0,
AttributeError: data
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
FAIL: CheckWeakReference2 (__main__.PgSQLTestCases)
----------------------------------------------------------------------
Traceback (most recent call last):
   File "test/PgSQLTestCases.py", line 338, in CheckWeakReference2
     self.failUnlessRaises(PgSQL.InterfaceError, self.cur.close)
   File "/var/tmp/python-root//usr/lib/python2.1/unittest.py", line 266, =

in failUnlessRaises
     raise self.failureException, excName
AssertionError: InterfaceError
----------------------------------------------------------------------
Ran 51 tests in 2.419s

FAILED (failures=3D1, errors=3D1)


What does that mean?

Best Regards,
Oliver

Re: [Pypgsql-users] setup on SuSE 7.3

[Gerhard <ger...@gm...>]

Le 18/02/02 ? 12:03, Oliver Vecernik écrivit:
> Meanwhile I installed the driver and ran the tests.
> 
> ...........................EF......................
> ======================================================================
> ERROR: CheckWeakReference1 (__main__.PgSQLTestCases)
> ----------------------------------------------------------------------
> Traceback (most recent call last):
>   File "test/PgSQLTestCases.py", line 333, in CheckWeakReference1
>     self.assertEquals(len(self.cnx.cursors.data.keys()), 0,
> AttributeError: data
> ======================================================================
> FAIL: CheckWeakReference2 (__main__.PgSQLTestCases)
> ----------------------------------------------------------------------
> Traceback (most recent call last):
>   File "test/PgSQLTestCases.py", line 338, in CheckWeakReference2
>     self.failUnlessRaises(PgSQL.InterfaceError, self.cur.close)
>   File "/var/tmp/python-root//usr/lib/python2.1/unittest.py", line 266, 
> in failUnlessRaises
>     raise self.failureException, excName
> AssertionError: InterfaceError
> ----------------------------------------------------------------------
> Ran 51 tests in 2.419s
> 
> FAILED (failures=1, errors=1)
> 
> 
> What does that mean?

The 'what' is not difficult: it checks wether there really aren't any
cursors left for the test connection.

As for the 'why', I currently have no idea. You haven't changed anything
in the PgSQLTestCases.py file except maybe the line building the
database connection, did you?

Gerhard
-- 
mail:   gerhard <at> bigfoot <dot> de       registered Linux user #64239
web:    http://www.cs.fhm.edu/~ifw00065/    OpenPGP public key id 86AB43C0
public key fingerprint: DEC1 1D02 5743 1159 CD20  A4B6 7B22 6575 86AB 43C0
reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))

Re: [Pypgsql-users] setup on SuSE 7.3

[Oliver V. <vec...@ao...>]

Gerhard H=E4ring wrote:

> Le 18/02/02 ? 12:03, Oliver Vecernik =E9crivit:
>=20
>>Meanwhile I installed the driver and ran the tests.
>>
>>...........................EF......................
>>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>>ERROR: CheckWeakReference1 (__main__.PgSQLTestCases)
>>----------------------------------------------------------------------
>>Traceback (most recent call last):
>>  File "test/PgSQLTestCases.py", line 333, in CheckWeakReference1
>>    self.assertEquals(len(self.cnx.cursors.data.keys()), 0,
>>AttributeError: data
>>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>>FAIL: CheckWeakReference2 (__main__.PgSQLTestCases)
>>----------------------------------------------------------------------
>>Traceback (most recent call last):
>>  File "test/PgSQLTestCases.py", line 338, in CheckWeakReference2
>>    self.failUnlessRaises(PgSQL.InterfaceError, self.cur.close)
>>  File "/var/tmp/python-root//usr/lib/python2.1/unittest.py", line 266,=
=20
>>in failUnlessRaises
>>    raise self.failureException, excName
>>AssertionError: InterfaceError
>>----------------------------------------------------------------------
>>Ran 51 tests in 2.419s
>>
>>FAILED (failures=3D1, errors=3D1)
>>
>>
>>What does that mean?
>>
>=20
> The 'what' is not difficult: it checks wether there really aren't any
> cursors left for the test connection.
>=20
> As for the 'why', I currently have no idea. You haven't changed anythin=
g
> in the PgSQLTestCases.py file except maybe the line building the
> database connection, did you?

I didn't change anything in PgSQLTestCases.py, I simply started it to=20
check my installation.

Oliver