Thread: psql (frontend) segfaults

psql (frontend) segfaults

From
Piotr Krukowiecki
Date:
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Piotr Krukowiecki
Your email address    : piotr@pingu.ii.uj.edu.pl


System Configuration
---------------------
  Architecture (example: Intel Pentium)      : Athlon 550

  Operating System (example: Linux 2.0.26 ELF)     : Linux 2.2.19 (RH)

  PostgreSQL version (example: PostgreSQL-7.1.1):   PostgreSQL-7.1.2

  Compiler used (example:  gcc 2.95.2)        : egcs-2.91.66


Please enter a FULL description of your problem:
------------------------------------------------

Today i upgraded postgres from 7.0.3 to 7.1.2.
First i pg_dump one database, and after installing new postgres i restored
database from dump file.
Then i tried this:
ankiety=> SELECT * from pasjans ;
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Backend sent D message without prior T
Segmentation fault
[piotr@pingu pgsql-backup]$

About database:
ankiety=> \d
        List of relations
    Name     |   Type   |  Owner
-------------+----------+---------
 pasjans     | table    | ankiety
 seq_pasjans | sequence | ankiety
(2 rows)

ankiety=> \d pasjans
                          Table "pasjans"
     Attribute     |  Type   |               Modifier
-------------------+---------+--------------------------------------
 klucz             | integer | default nextval('seq_pasjans'::text)
 nr_algorytmu      | integer | not null
 ilosc_ukrytych    | integer | not null
 ilosc_rotacyjnych | integer | not null
 k0                | integer | not null
 k1                | integer | not null
 k2                | integer | not null
[and so on to k61]
Index: ind_pasjans

ankiety=> SELECT count(*) from pasjans ;
 count
--------
 100121
(1 row)


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

The problem is fully repeatable. I don't have time now to check it more.
Send me mail for more information.