Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!goblin2!goblin.stu.neva.ru!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.004 X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'error:': 0.05; 'importerror:': 0.05; 'installed.': 0.05; 'dependency': 0.07; 'postgresql': 0.07; 'problem?': 0.07; 'python': 0.09; 'failed:': 0.09; '2.7': 0.13; '"import': 0.16; '4.1.1': 0.16; 'alexandra': 0.16; 'received:50.23': 0.16; 'subject:python2.7': 0.16; 'wrote:': 0.17; 'windows': 0.19; 'load': 0.19; 'versions': 0.20; 'trying': 0.21; 'import': 0.21; 'defined': 0.22; 'runs': 0.22; 'installed': 0.23; 'command': 0.24; 'header:In-Reply-To:1': 0.25; 'header:User- Agent:1': 0.26; 'dll': 0.27; 'fine': 0.28; 'run': 0.28; '(maybe': 0.29; "i'm": 0.29; 'compatible': 0.30; 'running': 0.32; 'anyone': 0.33; 'to:addr:python-list': 0.33; 'thanks': 0.34; 'pm,': 0.35; 'operating': 0.36; 'subject:: ': 0.38; 'some': 0.38; 'to:addr:python.org': 0.39; 'received:192': 0.39; 'hello,': 0.39; 'received:192.168': 0.40; 'help': 0.40; 'kind': 0.61; 'due': 0.66; 'revealed': 0.75; '2.7.': 0.84; '8.3': 0.84; '8.4': 0.84; 'received:192.168.13': 0.84; 'to:name:python': 0.84; 'received:co.il': 0.91; 'received:il': 0.91 X-Virus-Scanned: amavisd-new at compulab.co.il Date: Sun, 03 Feb 2013 13:14:34 +0200 From: alexandra User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:14.0) Gecko/20120714 Thunderbird/14.0 MIME-Version: 1.0 To: Python Subject: Re: PyGresql 4.1.1 for python2.7 References: <510A6BA4.4070306@compulab.co.il> In-Reply-To: <510A6BA4.4070306@compulab.co.il> Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - softlayer.compulab.co.il X-AntiAbuse: Original Domain - python.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - compulab.co.il X-Get-Message-Sender-Via: softlayer.compulab.co.il: acl_c_relayhosts_text_entry: alexandra@compulab.co.il|compulab.co.il X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 47 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1359890080 news.xs4all.nl 6976 [2001:888:2000:d::a6]:60176 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:38103 Using dependency walker revealed that the following are missing from libpq:
PQescapeLiteral
PQescapeIdentifier
These are only defined in postgresql 9.
Documentation states that PyGresql 4.1.1 is compatible with PostgreSQL 8.3 or higher and I'm using 8.4.
Has anyone else had this problem?

On 01/31/2013 03:03 PM, alexandra wrote:

Hello,

I'm trying to upgrade to python2.7.
Installed PyGresql 4.1.1 for python 2.7.
When running "import pg" command I get the following error:

from _pg import *
ImportError: DLL load failed: The operating system cannot run %1.

I'm using Windows XP SP3, and have PostgreSQL 8.4 installed.
The command runs fine in python 2.6.

Is this due to having multiple versions of python installed? Or some kind of dll incompatibility with 2.7 (maybe libpq.dll)?

Thanks for the help