Harald Armin Massa | 12 Oct 2008 19:41
Picon

win32 builds for python 2.5 against postgresql 8.3.4

hello,

postgresql 8.3.4 libpq fixes a nasty bug that's been there for years:
transfers of elements larger then xx where truncated by windows.

so, it would be nice to have binaries build against 8.3.4 libpq ... is
anybody planning to create them?

best wishes

Harald

--

-- 
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!
Karsten Hilbert | 12 Oct 2008 20:14
Picon

Re: win32 builds for python 2.5 against postgresql 8.3.4

On Sun, Oct 12, 2008 at 07:41:30PM +0200, Harald Armin Massa wrote:

> postgresql 8.3.4 libpq fixes a nasty bug that's been there for years:
> transfers of elements larger then xx where truncated by windows.

LOL, good to know :-)  We've been having a workaround in
GNUmed for ages where we download bytea fields in
user-definably sized parts with

	select substring ( from ... to ...) ...

Karsten
--

-- 
GPG key ID E4071346  <at>  wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
Harald Armin Massa | 12 Oct 2008 22:07
Picon

Re: win32 builds for python 2.5 against postgresql 8.3.4

> LOL, good to know :-)  We've been having a workaround in
> GNUmed for ages where we download bytea fields in
> user-definably sized parts with
>
>        select substring ( from ... to ...) ...
>
my workaround was having one table for files up to  x MB and another
for larger ones, which got cut down :(

Harald

--

-- 
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!
Jason Erickson | 12 Oct 2008 22:41

Re: win32 builds for python 2.5 against postgresql 8.3.4

On Sun, 12 Oct 2008, Harald Armin Massa wrote:

> hello,
>
> postgresql 8.3.4 libpq fixes a nasty bug that's been there for years:
> transfers of elements larger then xx where truncated by windows.
>
> so, it would be nice to have binaries build against 8.3.4 libpq ... is
> anybody planning to create them?

Sure thing.  I have updated the installers on my page at:
   http://www.stickpeople.com/projects/python/win-psycopg/index.html

They are now built against PostgreSQL 8.3.4.

Also, for those adventurous souls that are running on Windows x64 (and are 
using the amd64 built python 2.6), I have built an installer for that 
python as well, located on that page.

> best wishes
>
> Harald

-jason
Raj K | 14 Oct 2008 15:08
Picon

Reg: Installation problems in psycopg2

Hi all,
    I am trying to install psycopg2 in my windows machine for connecting with the PostgreSQL server.
    Since there is no binary executable*, I  am trying to build my own - and I am facing this issue.

C:\MinGW\bin\..\lib\gcc\mingw32\3.4.5\..\..\..\..\mingw32\bin\ld.exe:
cannot find -lpq
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1

     After a little bit of googling, I found that this can be solved by -L<directory name> while linking - but I am not specifically linking the code. Rather, I am installing by doing the following -
     python.exe setup.py build
     python.exe setup.py install

    So, I cannot find a place to include the -L option too.
    Can somebody help me on this? I have been investigating this for the last 4 days - and now I cannot see any further way out.

Regards,
Raj
*p.s ->  I did find one binary in
http://www.stickpeople.com/projects/python/win-psycopg/index.html#Ver....
But the licensing is GPL and I wont be able to use it (I am doing
coding for proprietary systems)
_______________________________________________
Psycopg mailing list
Psycopg@...
http://lists.initd.org/mailman/listinfo/psycopg
James Henstridge | 14 Oct 2008 15:49
Picon
Gravatar

Re: Reg: Installation problems in psycopg2

On Tue, Oct 14, 2008 at 9:08 PM, Raj K <raj.indian.08@...> wrote:
> *p.s ->  I did find one binary in
> http://www.stickpeople.com/projects/python/win-psycopg/index.html#Ver....
> But the licensing is GPL and I wont be able to use it (I am doing
> coding for proprietary systems)

Presumably the code in those Windows builds is identical to that in
the source releases, so there shouldn't be any difference between
compiling it yourself and using that build.  That website should
probably make this clear.

James.
Jason Erickson | 15 Oct 2008 06:14

Re: Reg: Installation problems in psycopg2

On Tue, 14 Oct 2008, Raj K wrote:

> Hi all,
>    I am trying to install psycopg2 in my windows machine for connecting
> with the PostgreSQL server.
>    Since there is no binary executable*, I  am trying to build my own - and
> I am facing this issue.
> C:\MinGW\bin\..\lib\gcc\mingw32\3.4.5\..\..\..\..\mingw32\bin\ld.exe:
> cannot find -lpq
> collect2: ld returned 1 exit status
> error: command 'gcc' failed with exit status 1
>
>     After a little bit of googling, I found that this can be solved by
> -L<directory name> while linking - but I am not specifically linking the
> code. Rather, I am installing by doing the following -
>     python.exe setup.py build
>     python.exe setup.py install
>
>    So, I cannot find a place to include the -L option too.
>    Can somebody help me on this? I have been investigating this for the
> last 4 days - and now I cannot see any further way out.
> Regards,
> Raj

Ahh, the mysteries of distutils.  Very powerful, but strangely, not a lot 
of information available on it.  Several years back, I was making a simple 
windows script to build the psycopg packages and somehow came up with 
these gems:

     python.exe setup.py clean --all
     python.exe setup.py build_ext -L <';' separated list of additional lib 
dirs to search> -I <';' separated list of additional include dirs to 
search> bdist_wininst

I highly recommend 'clean --all' before doing anything.

From what I remember, the flags -L and -I only work with build_ext (and 
maybe build_clib).  If you want to do more (install it, build binaries, 
etc), you can place additional commands at the end of the line after the 
-L and -I flags.  Some experimentation will be required.  In a nutshell, 
many flags are only valid with a particluar command, but you can chain 
commands together (aka build the extension before building the installer) 
to get the desired results you want.

> *p.s ->  I did find one binary in
> http://www.stickpeople.com/projects/python/win-psycopg/index.html#Ver...<http://www.stickpeople.com/projects/python/win-psycopg/index.html#Version2>.
>
> But the licensing is GPL and I wont be able to use it (I am doing
> coding for proprietary systems)

As James noted in another message, yes, the license of the psycopg windows 
binaries that I provide is intended to be the same as psycopg itself.  I 
do not claim any additional license(s) on the software, or want to change 
it.

To clairify things in the future, I have updated the information on my 
page to point to the LICENSE file included with psycopg.

-jason
Nathan | 16 Oct 2008 07:12
Picon
Gravatar

Fwd: [Bug 237849] Please bump dev-python/psycopg to 2.0.8

psycopg 2.0.8 is finally in portage (in Gentoo).  :-)

~ Nathan

---------- Forwarded message ----------
From:  <bugzilla-daemon@...>
Date: Wed, Oct 15, 2008 at 3:18 PM
Subject: [Bug 237849] Please bump dev-python/psycopg to 2.0.8
To: nathan.stocks@...

DO NOT REPLY TO THIS EMAIL. Also, do not reply via email to the person
whose email is mentioned below. To comment on this bug, please visit:

Clear-Text: http://bugs.gentoo.org/show_bug.cgi?id=237849
Secure: https://bugs.gentoo.org/show_bug.cgi?id=237849

caleb@... changed:

          What    |Removed                     |Added
----------------------------------------------------------------------------
            Status|NEW                         |RESOLVED
        Resolution|                            |FIXED

------- Comment #2 from caleb@...  2008-10-15 21:18 0000 -------
bumped in portage, thanks for the report

--
Configure bugmail: https://bugs.gentoo.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You reported the bug, or are watching the reporter.
Nathan | 18 Oct 2008 21:53
Picon
Gravatar

Fwd: [Bug 242336] Stabilization request for psycopg 2.0.[6|7|8]

Anyone have any idea why John (below) would get that error trying to
import psycopg2 (2.0.8?)   This is an obstacle for getting 2.0.8
marked stable on Gentoo.

~ Nathan

---------- Forwarded message ----------
From:  <bugzilla-daemon@...>
Date: Sat, Oct 18, 2008 at 1:39 AM
Subject: [Bug 242336] Stabilization request for psycopg 2.0.[6|7|8]
To: nathan.stocks@...

DO NOT REPLY TO THIS EMAIL. Also, do not reply via email to the person
whose email is mentioned below. To comment on this bug, please visit:

Clear-Text: http://bugs.gentoo.org/show_bug.cgi?id=242336
Secure: https://bugs.gentoo.org/show_bug.cgi?id=242336

------- Comment #1 from john.mcfarlane@...  2008-10-18 07:39
0000 -------
On my box 2.0.7 runs great, but 2.0.8 does not import properly:

jmcfarlane <at> monster # python
Python 2.5.2 (r252:60911, Sep 12 2008, 02:04:02)
[GCC 4.1.2 (Gentoo 4.1.2 p1.1)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import psycopg2
Traceback (most recent call last):
 File "<stdin>", line 1, in <module>
 File "/usr/lib64/python2.5/site-packages/psycopg2/__init__.py", line 60, in
<module>
   from _psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: /usr/lib64/python2.5/site-packages/psycopg2/_psycopg.so: undefined
symbol: lo_create
>>>

I'm not yet certain if this is a problem local to me or not.  Here's my system
info in case anyone recognizes the problem:

jmcfarlane <at> monster # emerge --info
Portage 2.1.4.5 (default/linux/amd64/2008.0/desktop, gcc-4.1.2, glibc-2.6.1-r0,
2.6.25-gentoo-r7 x86_64)
=================================================================
System uname: 2.6.25-gentoo-r7 x86_64 Intel(R) Core(TM)2 CPU T7200  <at>  2.00GHz
Timestamp of tree: Sat, 18 Oct 2008 06:15:01 +0000
app-shells/bash:     3.2_p33
dev-java/java-config: 1.3.7, 2.1.6
dev-lang/python:     2.4.4-r14, 2.5.2-r7
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox:    1.2.18.1-r2
sys-devel/autoconf:  2.13, 2.61-r2
sys-devel/automake:  1.5, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.1-r1
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool:   1.5.26
virtual/os-headers:  2.6.23-r3
ACCEPT_KEYWORDS="amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=nocona -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/
/etc/fonts/fonts.conf /etc/gconf /etc/revdep-rebuild /etc/terminfo
/etc/texmf/web2c /etc/udev/rules.d"
CXXFLAGS="-march=nocona -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="distlocks metadata-transfer parallel-fetch sandbox sfperms strict
unmerge-orphans userfetch"
LANG="en_US.UTF-8"
LDFLAGS="-Wl,-O1"

--
Configure bugmail: https://bugs.gentoo.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You reported the bug, or are watching the reporter.
Federico Di Gregorio | 18 Oct 2008 22:19
Favicon
Gravatar

Re: Fwd: [Bug 242336] Stabilization request for psycopg 2.0.[6|7|8]

Il giorno sab, 18/10/2008 alle 13.53 -0600, Nathan ha scritto:
> Anyone have any idea why John (below) would get that error trying to
> import psycopg2 (2.0.8?)   This is an obstacle for getting 2.0.8
> marked stable on Gentoo.

His libpq is old and does not have lo_create.

federico

--

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                fog@...
INIT.D Developer                                           fog@...
                      The number of the beast: vi vi vi. -- Delexa Jones
_______________________________________________
Psycopg mailing list
Psycopg@...
http://lists.initd.org/mailman/listinfo/psycopg

Gmane