Your message dated Tue, 28 Jan 2014 21:24:30 +0000
with message-id <e1w8g90-0003ip...@franck.debian.org>
and subject line Bug#724597: fixed in py-postgresql 1.1.0-1
has caused the Debian Bug report #724597,
regarding python3-postgresql is broken with PostgreSQL 9.2+
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
724597: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=724597
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: python3-postgresql
Version: 1.0.2-1
Severity: grave
python3-postgresql needs porting to PostgreSQL 9.2 and later, where
pg_stat_activity.procpid got renamed to "pid":
$ python3
Python 3.3.2+ (default, Aug 4 2013, 15:50:24)
[GCC 4.8.1] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import postgresql
>>> db = postgresql.open("pq://localhost/postgres")
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 1460, in
_fini
self.database._pq_complete()
File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 2599, in
_pq_complete
self.typio.raise_error(x.error_message, cause = getattr(x, 'exception',
None))
File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 507, in
raise_error
self.raise_server_error(error_message, **kw)
File "/usr/lib/python3/dist-packages/postgresql/driver/pq3.py", line 498, in
raise_server_error
raise server_error
postgresql.exceptions.UndefinedColumnError: Spalte »procpid« existiert nicht
CODE: 42703
LOCATION: File 'parse_expr.c', line 768, in transformColumnRef from SERVER
POSITION: 147
STATEMENT: [parsing]
LINE:
FROM pg_catalog.pg_stat_activity WHERE procpid = pg_catalog.pg_backend_pid()
^ [line 6, character 40]
statement_id: py:0x7f8b8055d9d0
string:
SYMBOL: startup_data
source:
SELECT
pg_catalog.version()::text AS version,
backend_start::text,
client_addr::text,
client_port::int
FROM pg_catalog.pg_stat_activity WHERE procpid =
pg_catalog.pg_backend_pid()
UNION ALL SELECT
pg_catalog.version()::text AS version,
NULL::text AS backend_start,
NULL::text AS client_addr,
NULL::int AS client_port
LIMIT 1;
LIBRARY: /usr/share/python3-postgresql/libsys.sql
CONNECTION: [closed]
CONNECTOR: [Host] pq://cbe:***@localhost:5432/postgres
category: None
DRIVER: postgresql.driver.pq3.Driver
-- System Information:
Debian Release: jessie/sid
APT prefers testing
APT policy: (700, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 3.10-2-amd64 (SMP w/8 CPU cores)
Locale: LANG=de_DE.utf8, LC_CTYPE=de_DE.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages python3-postgresql depends on:
ii libc6 2.17-92+b1
ii libjs-jquery 1.7.2+dfsg-3
ii python3 3.3.2-15
python3-postgresql recommends no packages.
python3-postgresql suggests no packages.
-- no debconf information
Christoph
--
c...@df7cb.de | http://www.df7cb.de/
signature.asc
Description: Digital signature
--- End Message ---
--- Begin Message ---
Source: py-postgresql
Source-Version: 1.1.0-1
We believe that the bug you reported is fixed in the latest version of
py-postgresql, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 724...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Daniel Kahn Gillmor <d...@fifthhorseman.net> (supplier of updated py-postgresql
package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@ftp-master.debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Thu, 23 Jan 2014 13:44:16 -0500
Source: py-postgresql
Binary: python3-postgresql
Architecture: source amd64
Version: 1.1.0-1
Distribution: unstable
Urgency: low
Maintainer: William Grzybowski <will...@agencialivre.com.br>
Changed-By: Daniel Kahn Gillmor <d...@fifthhorseman.net>
Description:
python3-postgresql - pgsql driver, cluster management tools, and client tools
Closes: 724597 736447 736450
Changes:
py-postgresql (1.1.0-1) unstable; urgency=low
.
[ Jakub Wilk ]
* Use canonical URIs for Vcs-* fields.
.
[ Daniel Kahn Gillmor ]
* New upstream release (Closes: #736447, #724597)
* update debian/watch (Closes: #736450)
* bump debhelper to 9
* Add dependency on python3-ipaddr
* bump Standards-Version to 3.9.5 (no changes needed)
* refreshed add_libpath.patch
* added myself to Uploaders as part of the python-modules-team
* replaced resolved/crypt with crypt from libpython3-stdlib to reduce
licensing silliness
Checksums-Sha1:
22af099497153278fe3d8121020bddeb8b26a9de 2240 py-postgresql_1.1.0-1.dsc
ce0a976ae0ae7cd6cdaa3096ec52d117408504de 264510 py-postgresql_1.1.0.orig.tar.gz
69443c2d21b813eeee3a1a3624ae413bd0e24c69 4732
py-postgresql_1.1.0-1.debian.tar.xz
f9b1cb8adeeca3d4e391b0ab05b40d395880bb99 954488
python3-postgresql_1.1.0-1_amd64.deb
Checksums-Sha256:
9402caff8ea5b7b60f0d89c808c4a1323e1bacece2e24a710f514373f3592afc 2240
py-postgresql_1.1.0-1.dsc
8d9d0f36c9b0ab4dbf45c3c0e30af2842b267776cdfdd17ed054ca33efce5c61 264510
py-postgresql_1.1.0.orig.tar.gz
b88dd37c4bc5036af4a3faf9df3cc27033da15659cf1c7abe2dec06ad527b6d6 4732
py-postgresql_1.1.0-1.debian.tar.xz
9520f0711db983f83cb5a962543bf8637d8316e42c7277e48852c547a1404369 954488
python3-postgresql_1.1.0-1_amd64.deb
Files:
df7072348902edd30adf558f1a2804d7 2240 python optional py-postgresql_1.1.0-1.dsc
8efe810a4abbbbe1c25b4fcef29421fa 264510 python optional
py-postgresql_1.1.0.orig.tar.gz
7a639ebed3e40bdc2de3af5da38ca6db 4732 python optional
py-postgresql_1.1.0-1.debian.tar.xz
ec3f8de0a90f7a988945c30283a1ed95 954488 python optional
python3-postgresql_1.1.0-1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQJ8BAEBCgBmBQJS6AsWXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w
ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXRFQjk2OTEyODdBN0FEREUzNzU3RDkxMUVB
NTI0MDFCMTFCRkRGQTVDAAoJEKUkAbEb/fpc3FYP/Am+ECS/R5XwwOFCKCz4nlBJ
QSstfktovlMrbQnLAZSiR8iDWTbKMxZjEcf0IJ7IP5d+uWpAawUCFnas0jV+bkti
ZrJar7QPnuTTPRabHT8dv5DaTPfeXVphm3aOUA/fEiNg9QOtzhH7Kbvtkf4uZYzt
qAypU+8KHy5AK6w1HYQywJisd+aXQl/0VP0oA17/eVIrhqeRw2yi+wx5yNGvpnMC
8pKRuYNR87PnkZFQHi2k7BOpn5/UV3C8QZk6lMQF05a5vwd0gqFco5OzYrA+Eqca
opbrUIPMKY2GTZmKWg6+/XD6SuTLvH0xKQV8zUHJdnVtWuZU8GSkadBUcpR8Nka5
kNvVMGlVkc/gXJdJvzCum2kEayuJ/Msq45VNTs29QXQ2NRxn2Zqjh/aqPr6ralo8
dvtunc6LeHnB7blsVxQukNNC7kzeqhH0nBFe9sFN2VkEAIvEJk2cJHDlKPuzdJsm
yEm5Nxxd/89VOUmINza81oWczmMPEqWSWtJ+WIQ5yYlVa7nvvGcJkUvF/ucSlpjD
zY3BL6ovgYXmK8nNIPI+lG5ZJ6vWbuD+ey8RS4/EcKtjm3LrJv6TzMpwjKZy69h2
Mx0JhUXtrHU38xNJrbjV7b1MfARI3mh8F1ApZgQeZo1SCWopwRl0GXMxSfATb1BN
HweveC6VLP4wWEDRY6E3
=l6Xz
-----END PGP SIGNATURE-----
--- End Message ---
