Your message dated Wed, 19 Jun 2013 14:52:38 +0200
with message-id <[email protected]>
and subject line Re: Bug#650380: postgresql-8.4: Unaligned output format not
working correctly
has caused the Debian Bug report #650380,
regarding postgresql-8.4: Unaligned output format not working correctly
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.)
--
650380: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=650380
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-8.4
Version: 8.4.8-0squeeze2
Severity: normal
The unaligned output format of the psql command is only half functioning
in this version.
If you try "psql -l" as user postgres you see a list of databases in
aligned and line wrapped format.
To get a unaligned and line unwrapped format you can either use "-P
Unaligned" or the -A switch normally. But this does not work here.
The output is unaligned, BUT its NOT unwrapped, which makes it hard to
script that output for example for backups.
I tried to set the columns (-P columns=300) or COLUMNS=300 psql ... but
this also does not work.
I did not check the postgresql changelog but I did never experience this
behavior on earlier versions.
-- System Information:
Debian Release: 6.0.3
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.0.4-hardened-r2 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages postgresql-8.4 depends on:
ii libc6 2.11.2-10 Embedded GNU C Library: Shared lib
ii libcomerr2 1.41.12-4stable1 common error description library
ii libgssapi-krb5-2 1.8.3+dfsg-4squeeze2 MIT Kerberos runtime libraries - k
ii libkrb5-3 1.8.3+dfsg-4squeeze2 MIT Kerberos runtime libraries
ii libldap-2.4-2 2.4.23-7.2 OpenLDAP libraries
ii libpam0g 1.1.1-6.1 Pluggable Authentication Modules l
ii libpq5 8.4.8-0squeeze2 PostgreSQL C client library
ii libssl0.9.8 0.9.8o-4squeeze3 SSL shared libraries
ii libxml2 2.7.8.dfsg-2+squeeze1 GNOME XML library
ii locales 2.11.2-10 Embedded GNU C Library: National L
ii postgresql-client- 8.4.8-0squeeze2 front-end programs for PostgreSQL
ii postgresql-common 113 PostgreSQL database-cluster manage
ii ssl-cert 1.0.28 simple debconf wrapper for OpenSSL
ii tzdata 2011k-0squeeze1 time zone and daylight-saving time
postgresql-8.4 recommends no packages.
Versions of packages postgresql-8.4 suggests:
pn oidentd | ident-server <none> (no description available)
-- no debconf information
--- End Message ---
--- Begin Message ---
Re: Marc Schiffbauer 2011-11-29
<[email protected]>
> The unaligned output format of the psql command is only half functioning
> in this version.
>
> If you try "psql -l" as user postgres you see a list of databases in
> aligned and line wrapped format.
>
> To get a unaligned and line unwrapped format you can either use "-P
> Unaligned" or the -A switch normally. But this does not work here.
>
> The output is unaligned, BUT its NOT unwrapped, which makes it hard to
> script that output for example for backups.
Hi Marc,
sorry for the late feedback.
This has been a general change in PostgreSQL 8.4 that permissions and
similar things are distributed over several lines in backslash
commands (\l = psql -l).
I don't think the unaligned mode is really supposed to work with the
output of backslash commands - use SQL queries instead. The query used
to produce the -l (\l) output can be seen by running "psql -E -l".
I'll close the Debian bug - changing the behavior would need someone
submitting a patch to PostgreSQL upstream.
Christoph
--
[email protected] | http://www.df7cb.de/
--- End Message ---
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
