psql (frontend) segfaults

From: Piotr Krukowiecki <piotr(at)pingu(dot)ii(dot)uj(dot)edu(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: psql (frontend) segfaults
Date: 2001-06-18 19:59:35
Message-ID: 20010618215935.A16778@pingu.ii.uj.edu.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Piotr Krukowiecki
Your email address : piotr(at)pingu(dot)ii(dot)uj(dot)edu(dot)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(at)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-06-19 15:01:19 Memory leak in 7.0.3 JDBC driver
Previous Message Stephan Szabo 2001-06-18 18:03:32 Re: Referential integrity problem