Segmentation fault when choosing (inquiring) SELECT - Mailing list pgsql-bugs

Hi,

I use PostgreSQL 7.3.2.

Choosing selection for a table I get Segmentation fault.

Namely:

1.=> \d aer_trips
 uin       | integer | default nextval('aer_trips_seq'::text)
 l         | integer |
 l_type    | integer |
 name      | text    |
 descr     | text    |
 foto_trip | text    |
 descript  | text    |
 keywords  | text    |

2.=> select uin,l,l_type,name,foto_trip,descript,keywords from aer_trips where uin=172;
 uin |  l  | l_type |              name               | foto_trip | descript | keywords
-----+-----+--------+---------------------------------+-----------+----------+----------
 172 | 103 |      2 | çÁ×ÁÎÁ. óÅÚÏÎ ÚÉÍÁ-×ÅÓÎÁ 2005Ç. |           |          |
(1 row)


3.=> select * from aer_trips where uin>170;
 172 | 103 |      2 | çÁ×ÁÎÁ. óÅÚÏÎ ÚÉÍÁ-×ÅÓÎÁ 2005Ç.
    | <b>Melia Cohiba*****Super</b><br>
ïÔÅÌØ ÒÁÓÐÏÌÏÖÅÎ × ÓÁÍÏÍ ÃÅÎÔÒÅ çÁ×ÁÎÙ, ÒÑÄÏÍ Ó ÎÁÂÅÒÅÖÎÏÊ íÁÌÅËÏÎ. ÷ ÏÔÅÌÅ: 342 Ä×ÕÈÍÅÓÔÎÙÈ ÎÏÍÅÒÁ, 39 ÀÎÉÏÒ-ÓØÀÔÏ× Ó
 ÄÖÁËÕÚÉ, 81 ÓØÀÔ. ÷Ï ×ÓÅÈ ÎÏÍÅÒÁÈ ×ÉÄ ÎÁ ÍÏÒÅ ÉÌÉ ÍÏÒÅ/ÇÏÒÏÄ, ËÏÎÄÉÃÉÏÎÅÒ, ÔÅÌÅÆÏÎ, ÓÐÕÔÎÉËÏ×ÏÅ ÔÅÌÅ×ÉÄÅÎÉÅ, ÒÁÄÉÏ, Í
ÉÎÉ-ÂÁÒ, ÓÅÊÆ, ×ÁÎÎÁÑ ËÏÍÎÁÔÁ Ó ÆÅÎÏÍ, ÏÂÓÌÕÖÉ×ÁÎÉÅ ÎÏÍÅÒÏ× 24 ÞÁÓÁ, ÄÏÓÔÕÐ Ë ÉÎÔÅÒÎÅÔÕ. ÷ 10-ÔÉ ÂÁÒÁÈ É ÒÅÓÔÏÒÁÎÁÈ ÏÔ
ÅÌÑ ×Ù ÎÁÊÄÅÔÅ ÓÁÍÕÀ ÌÕÞÛÕÀ ËÕÈÎÀ. ë ×ÁÛÉÍ ÕÓÌÕÇÁÍ ÂÁÓÓÅÊÎ, ÐÒÏËÁÔ ÍÁÛÉÎ, ÏÂÍÅÎ ÄÅÎÅÇ, ÐÁÒÉËÍÁÈÅÒÓËÁÑ, ÍÁÇÁÚÉÎÙ, ÓÁÕÎÁ
, ÍÁÓÓÁÖ, ÔÒÅÎÁÖÅÒÎÙÊ ÚÁÌ, ËÏÎÆÅÒÅÎÃ-ÚÁÌ.<br><br>

www.solmeliacuba.com<br>
<i>ãÅÎÙ ÕËÁÚÁÎÙ × å÷òï!</i><br>
<table cellspacing="1" cellpadding="0" border="0" width="100%" bgcolor="#000000">
<tr>
    <td width="50%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>ÐÅÒÉÏÄ</st
rong></td>
    <td width="5%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>ÔÉÐ ÎÏÍÅÒÁ<
/strong></td>
    <td width="5%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>ÔÉÐ ÐÉÔÁÎÉÑ
</strong></td>
    <td width="10%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>Ä×ÕÈÍ.</st
rong></td>
    <td width="10%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>ÏÄÎÏÍ.</st
rong></td>
    <td width="10%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>ÄÏÐ. ËÒÏ×Á
ÔØ</strong></td>
<td width="10%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>1-Ê ÒÅÂ. 2-12
ÌÅÔ</strong></td>
</tr>
<tr>
    <td width="50%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>03.01-30.0
4.05</strong></td>
    <td width="5%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>STD</strong
></td>
    <td width="5%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>ÚÁ×ÔÒÁË</st
rong></td>
    <td width="10%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>65</strong
></td>
    <td width="10%" bgcolor="#EFEFF7" style="padding-left : 5pt; padding-right : 5pt;" class="main"><strong>107</stron
g></td>
========================[cut]===================================

If choosing selection for only one row, then:

4.=> select * from aer_trips where uin=172;
Segmentation fault

Why does it happen so and what I should/must    do to avoid
 Segmentation fault when choosing selection for only _one_ row.

Thanx.


--
Alexey Vlasov
DataForce IP, Support Team
+7 (095) 737-5667; support@df.ru
http://support.df.ru/