Package: postgresql
Version: 7.4.7-6sarge2
Severity: normal
*** Please type your report below this line ***
Since update to postgresql7.4.7-6sarge2 is the option -l not correct.
I've checked multiple Situations:
If template0 and/or template1 coded with UNICODE then the call to psql
-l
abort with Error (in german):
Fehler: ungültige Byte-Sequenz für Kodierung "UNICODE":0x7c6d65
If template0 and template1 coded with SQL_ASCII then the call to psql -l
give the correct result.
If i connected to a database coded with UNICODE then the command \l
abort
with the same Error (0x7c6d65).
------------------------------------------------------------------------
[EMAIL PROTECTED]:/tmp$ psql testbug
Willkommen bei psql 7.4.7, dem interaktiven PostgreSQL-Terminal.
Geben Sie ein: \copyright für Urheberrechtsinformationen
\h für Hilfe über SQL-Anweisungen
\? für Hilfe über interne Anweisungen
\g oder Semikolon, um eine Anfrage auszuführen
\q um zu beenden
testbug=# \l
FEHLER: ungültige Byte-Sequenz für Kodierung »UNICODE«: 0xfc6d65
------------------------------------------------------------------------
If i connected to a database coded with SQL_ASCII or LATIN9 then the
command \l give the correct result.
------------------------------------------------------------------------
testbug=# \c uwe
Sie sind jetzt mit der Datenbank »uwe« verbunden.
uwe=# \l
Liste der Datenbanken
Name | Eigentümer | Kodierung
------------------+------------+-----------
<snip>
template0 | postgres | LATIN9
template1 | postgres | LATIN9
testbug | uwe | UNICODE
<snip>
uwe | uwe | LATIN9
<snip>
(18 Zeilen)
------------------------------------------------------------------------
I've checked this with an i386-Version and an AMD64-Version.
-- System Information:
Debian Release: 3.1
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.8-3-k7
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)
Versions of packages postgresql depends on:
ii adduser 3.63 Add and remove users and
groups
ii debconf [debconf 1.4.30.13 Debian configuration
management sy
ii debianutils 2.8.4 Miscellaneous utilities
specific t
ii dpkg 1.10.28 Package maintenance system
for Deb
ii libc6 2.3.2.ds1-22sarge3 GNU C Library: Shared
libraries an
ii libcomerr2 1.37-2sarge1 common error description
library
ii libkrb53 1.3.6-2sarge2 MIT Kerberos runtime
libraries
ii libpam0g 0.76-22 Pluggable Authentication
Modules l
ii libperl5.8 5.8.4-8sarge4 Shared Perl library
ii libpq3 7.4.7-6sarge2 PostgreSQL C client library
ii libreadline4 4.3-11 GNU readline and history
libraries
ii libssl0.9.7 0.9.7e-3sarge1 SSL shared libraries
ii mailx 1:8.1.2-0.20040524cvs-4 A simple mail user agent
ii postgresql-clien 7.4.7-6sarge2 front-end programs for
PostgreSQL
ii procps 1:3.2.1-2 The /proc file system
utilities
ii python2.3 2.3.5-3sarge1 An interactive high-level
object-o
ii ucf 1.17 Update Configuration File:
preserv
ii zlib1g 1:1.2.2-4.sarge.2 compression library -
runtime
-- debconf information:
* postgresql/initdb/location: /var/lib/postgres/data
postgresql/upgrade/preserve_location: $PGDATA/..
* postgresql/settings/day_month_order: European
postgresql/upgrade/policy: true
* postgresql/settings/locale: [EMAIL PROTECTED]
postgresql/enable_lang: true
* postgresql/purge_data_too: false
postgresql/very_old_version_warning: true
postgresql/upgrade/dump_location: $PGDATA/..
postgresql/convert-pg_hba.conf: true
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
