connecting to databases does not work

[Ulf Mehlig]

Connection attempts to databases on localhost and on remote hosts fail with the following error messages (user name, password and database name substituted by placeholders):

Python 3.3.1 (default, Apr 17 2013, 22:30:32)
[GCC 4.7.3] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import postgresql
>>> db = postgresql.open("pq://theusername:thepasswd@localhost/thedatabasename")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib/python3/dist-packages/postgresql/__init__.py", line 88, in open
    c.connect()
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 2559, in connect
    sd = self.sys.startup_data()
  File "/usr/lib/python3/dist-packages/postgresql/lib/__init__.py", line 398, in __getattr__
    bs = BoundSymbol(sym, db)
  File "/usr/lib/python3/dist-packages/postgresql/lib/__init__.py", line 288, in __init__
    ps = database.prepare(symbol)
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 2352, in prepare
    ps._fini()
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 1482, in _fini
    self._output_io = typio.resolve_descriptor(tupdesc, 1)
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 220, in resolve_descriptor
    (self.resolve(x[3]) or (None, None))[index] for x in desc
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 220, in <listcomp>
    (self.resolve(x[3]) or (None, None))[index] for x in desc
  File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 243, in resolve
    typio = builtins(typid)
  File "/usr/lib/python3/dist-packages/postgresql/types/io/__init__.py", line 96, in resolve
    module_io.update(load(io).oid_to_io)
  File "/usr/lib/python3/dist-packages/postgresql/types/io/__init__.py", line 89, in load
    return __import__(__name__ + '.' + relmod, fromlist = True, level = 1)
KeyError: "'__name__' not in globals"

This used to work in 12.10. Accessing the database is possible by using other tools (e.g., psql -h 127.0.0.1 -U therusername the databasename). The postgres server is postgresql-9.1 (9.1.9-1ubuntu1). If more information is necessary, please let me know.

ProblemType: Bug
DistroRelease: Ubuntu 13.04
Package: python3-postgresql 1.0.2-1build2
ProcVersionSignature: Ubuntu 3.8.0-21.32-generic 3.8.8
Uname: Linux 3.8.0-21-generic x86_64
ApportVersion: 2.9.2-0ubuntu8
Architecture: amd64
Date: Wed May 22 07:00:41 2013
InstallationDate: Installed on 2013-03-07 (75 days ago)
InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5)
MarkForUpload: True
ProcEnviron:
 TERM=xterm
 PATH=(custom, no user)
 XDG_RUNTIME_DIR=<set>
 LANG=en_GB.UTF-8
 SHELL=/bin/bash
SourcePackage: py-postgresql
UpgradeStatus: Upgraded to raring on 2013-04-27 (24 days ago)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Tim Tugendhat (tugi)]

I can confirm this.
Since updating to raring, I have the same issue and can not connect to my db.
Any easy fixes?

[Atila (atilaromero)]

I was having the same error message, but fixed it installing postgresql-client (which I had removed some days before).
Anyone having this issue even with postgresql-client installed?

[Atila (atilaromero)]

No, false alarm, still confirmed even with postgresql-client.

[Atila (atilaromero)]

Workaround:
in file /usr/lib/python3/dist-packages/postgresql/types/io/__init__.py
change line 89
        return __import__(__name__ + '.' + relmod, fromlist = True, level = 1)
to
        return __import__(__name__ + '.' + relmod, fromlist = True)

Worked for me, but I'm not sure if it breaks something else.

[Patrik Lundquist (patrik-lundquist)]

Version 1.0.2 doesn't support Python 3.3 properly.

It was fixed upstream with commit https://github.com/python-postgres/fe/commit/272edfcd2a008aba1b97170a2138e8a91cb67177

Launchpad needs to import a newer upstream version.

[Ubuntu Foundations Team Bug Bot (crichton)]

The attachment "Patch for postgresql/types/io/__init__.py" seems to be a patch. If it isn't, please remove the "patch" flag from the attachment, remove the "patch" tag, and if you are a member of the ~ubuntu-reviewers, unsubscribe the team.

[This is an automated message performed by a Launchpad user owned by ~brian-murray, for any issues please contact him.]

[William Grzybowski (william88)]

This should have been fixed in 1.1.0