Your message dated Mon, 05 May 2008 21:02:52 +0000
with message-id <[EMAIL PROTECTED]>
and subject line Bug#469715: fixed in postgresql-autodoc 1.31-1
has caused the Debian Bug report #469715,
regarding postgresql-autodoc: Foreign key handling fails with new release of
DBD::Pg
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 [EMAIL PROTECTED]
immediately.)
--
469715: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=469715
Debian Bug Tracking System
Contact [EMAIL PROTECTED] with problems
--- Begin Message ---
Package: postgresql-autodoc
Version: 1.30-2
Severity: important
When running with the following version of libdbd-pg-perl, handling of
the "foreign key" section of postgresql-autodoc fails
[EMAIL PROTECTED]:/tmp> dpkg -l libdbd-pg-perl | grep ii
ii libdbd-pg-perl 2.1.3-3 Perl DBI
driver for the PostgreSQL database server
[EMAIL PROTECTED]:~/architecture/contacts> /usr/bin/postgresql_autodoc -d
newcontacts -h localhost -p 5433 -u cbbrowne -s public
DBD::Pg::st execute failed: ERROR: invalid input syntax for integer:
"ARRAY(0x84978fc)"
DBD::Pg::st fetchrow_hashref failed: no statement executing
(and similar errors, with different values for the ARRAY(), every time
autodoc discovers a foreign key)
Graphs and diagrams are successfully generated, after this, however they
lack data about foreign keys, which significantly degrades usability.
It seems likely to me that a proper resolution to this is to indicate
a version dependancy in postgresql-autodoc for version 1.49 of
libdbd-pg-perl.
Note: I have reported the issue upstream to the author (Rod Taylor,
[EMAIL PROTECTED]); there should eventually be an updated version of
autodoc that accomodates newer versions of DBD::Pg, but I think that
there will be some degree of version dependancy that isn't presently
expressed in the packaging.
Note, I have been able to successfully work around the matter by
downgrading to version 1.49-5 of libdbd-pg-perl.
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)
Kernel: Linux 2.6.22-1-686 (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash
Versions of packages postgresql-autodoc depends on:
ii libdbd-pg-perl 1.49-5 Perl DBI driver for the PostgreSQL
ii libhtml-template-perl 2.9-1 HTML::Template : A module for usin
ii libterm-readkey-perl 2.30-3 A perl module for simple terminal
ii perl 5.8.8-12 Larry Wall's Practical Extraction
Versions of packages postgresql-autodoc recommends:
ii chimera2 [www-browser] 2.0a19-5 Web browser for X
ii dia 0.96.1-6 Diagram editor
ii dia-gnome 0.96.1-6 Diagram editor (GNOME version)
ii dillo [www-browser] 0.8.6-2 Small and fast web browser
ii docbook-defguide [docbo 2.0.17+svn7549-2 DocBook: The Definitive Guide - HT
ii elinks [www-browser] 0.11.3-4 Advanced text-mode WWW browser
ii epiphany-gecko [www-bro 2.20.3-1 Intuitive GNOME web browser - Geck
ii galeon [www-browser] 2.0.4-1 GNOME web browser for advanced use
ii graphviz 2.16.1-2 rich set of graph drawing tools
ii iceape-browser [www-bro 1.1.8-2 Iceape Navigator (Internet browser
ii iceweasel [www-browser] 2.0.0.12-1 lightweight web browser based on M
ii konqueror [www-browser] 4:3.5.9.dfsg.1-1 KDE's advanced file manager, web b
ii links2 [www-browser] 2.1pre33-1 Web browser running in both graphi
ii lynx [www-browser] 2.8.6-2 Text-mode WWW Browser
ii w3m [www-browser] 0.5.1-5.1+b1 WWW browsable pager with excellent
ii xemacs21-mule [www-brow 21.4.21-2 highly customizable text editor --
ii xemacs21-nomule [www-br 21.4.21-2 highly customizable text editor --
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: postgresql-autodoc
Source-Version: 1.31-1
We believe that the bug you reported is fixed in the latest version of
postgresql-autodoc, which is due to be installed in the Debian FTP archive:
postgresql-autodoc_1.31-1.diff.gz
to pool/main/p/postgresql-autodoc/postgresql-autodoc_1.31-1.diff.gz
postgresql-autodoc_1.31-1.dsc
to pool/main/p/postgresql-autodoc/postgresql-autodoc_1.31-1.dsc
postgresql-autodoc_1.31-1_all.deb
to pool/main/p/postgresql-autodoc/postgresql-autodoc_1.31-1_all.deb
postgresql-autodoc_1.31.orig.tar.gz
to pool/main/p/postgresql-autodoc/postgresql-autodoc_1.31.orig.tar.gz
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 [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Tim Retout <[EMAIL PROTECTED]> (supplier of updated postgresql-autodoc 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 [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.8
Date: Fri, 02 May 2008 00:45:52 +0100
Source: postgresql-autodoc
Binary: postgresql-autodoc
Architecture: source all
Version: 1.31-1
Distribution: unstable
Urgency: low
Maintainer: Tim Retout <[EMAIL PROTECTED]>
Changed-By: Tim Retout <[EMAIL PROTECTED]>
Description:
postgresql-autodoc - Utility to create a PostgreSQL database schema overview
in HTML,
Closes: 469715
Changes:
postgresql-autodoc (1.31-1) unstable; urgency=low
.
* New upstream version.
+ Fixes compatibility with recent libdbd-pg-perl. (Closes: #469715)
* debian/rules:
+ Touch config.mk before running 'make distribution-clean', so that we
never try to use upstream's rule to create it.
+ config.sub and config.guess are unused by ./configure, so remove
altogether.
* debian/control: Remove build dependency on autotools-dev.
* Makefile: Remove change to config.mk creation rule from Debian diff.
Checksums-Sha1:
848c79a58e386ca055e2b61928c4554c5591e1c7 1281 postgresql-autodoc_1.31-1.dsc
2f9dbd73593ce71229fcaf72d5e69c18b8812117 48998
postgresql-autodoc_1.31.orig.tar.gz
f96dc681d0acc621a901b2024f1df998f9d8ebae 5004 postgresql-autodoc_1.31-1.diff.gz
e264f9fb26f4d747573f376a5149b96a76bba657 27958
postgresql-autodoc_1.31-1_all.deb
Checksums-Sha256:
f89f5587c1f0aeb9f6ddf77b2f35460765ed757dd4edddcddccd3560e637fc87 1281
postgresql-autodoc_1.31-1.dsc
6a683a32128e9553f1d5f7e67f934e148c1d5bf8041d5807695739a654581e5b 48998
postgresql-autodoc_1.31.orig.tar.gz
13bb41a30213124812cdb1cd8121aaf0c61eb3f1af19fa1fb04b7ee85088ef73 5004
postgresql-autodoc_1.31-1.diff.gz
0ac0de0e620a4cc94155a5a68ad28a241a529fe9f665ae36c3c9671035eb717f 27958
postgresql-autodoc_1.31-1_all.deb
Files:
775e7394176a680ce0240d7b2fe55c74 1281 utils optional
postgresql-autodoc_1.31-1.dsc
0dbb61cf8b78da7ae9d12221f7a14d27 48998 utils optional
postgresql-autodoc_1.31.orig.tar.gz
ce5ac0aabd59bab6c5d90b6e1f7b02fd 5004 utils optional
postgresql-autodoc_1.31-1.diff.gz
37f59b719604b3476d12bbb16ef071ff 27958 utils optional
postgresql-autodoc_1.31-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFIH3DdNIW6CNDsByMRAqmiAJ99PRddbUfRUPFYKsRdFyeA6JVLSwCePj4z
v1Ysd4WAChIvaBEfhiL9POI=
=6TuO
-----END PGP SIGNATURE-----
--- End Message ---
