Thread: \l+ dumps core

\l+ dumps core

From
James Cribb
Date:
I installed the postgresql-7.0.2-2 RPM downloaded from postgres.org, but \l+
always dumps core:


% psql
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

jamesc=# select version();
                               version
---------------------------------------------------------------------
 PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
(1 row)

jamesc=# \l+
               List of databases
 Database  |  Owner   | Encoding  | Description
-----------+----------+-----------+-------------
 jamesc    | jamesc   | SQL_ASCII |
 template1 | postgres | SQL_ASCII |
(2 rows)

zsh: segmentation fault (core dumped)  psql
%

Re: \l+ dumps core

From
Tatsuo Ishii
Date:
> I installed the postgresql-7.0.2-2 RPM downloaded from postgres.org, but \l+
> always dumps core:

It's a bug in 7.0.2. Obtain a patch from:

ftp://ftp.sra.co.jp/pub/cmd/postgres/7.0.2/patches/psql.patch.gz

and rebuild the RPM.

Note that this was already fixed in CVS (both stable and current).
This seems to be yet another reason for 7.0.3...
--
Tatsuo Ishii