Bug report

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs(at)postgresql(dot)org(dot)

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

Your name : Andrea Baldoni
Your email address : abaldoni(at)tiscalinet(dot)it

System Configuration
---------------------
Architecture : Intel Pentium III 500

Operating System : Linux 2.4.0-test10 (same problem on 2.2.17),
debian 2.2

PostgreSQL version : PostgreSQL-6.5.2

Compiler used : gcc version 2.95.2 20000313

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

Creating tables (temp or normal) inside a transaction sometime fails,
ending with corruption in pg_attribute system data table (if I do
"select * from pg_attribute" the server crash). If I stop and restart the
server the problem remains... I must restore pg_attribute* files to make
things working. The file having the name of the table created sometime
remains in the file system.

Debug output:

.
.
pq_flush: send() failed: Bad file descriptor
pq_flush: send() failed: Bad file descriptor
pq_recvbuf: recv() failed: Bad file descriptor
ERROR: infinite recursion in proc_exit
pq_flush: send() failed: Bad file descriptor
NOTICE: AbortTransaction and not in in-progress state
pq_flush: send() failed: Bad file descriptor
pq_flush: send() failed: Bad file descriptor
pq_recvbuf: recv() failed: Bad file descriptor
ERROR: infinite recursion in proc_exit
.
.

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

I'm using many script like this one, accessing different tables, and I haven't
found differences.
Sample bash script:

#!/bin/bash
umask 077
cat << EOF |psql abaldoni 2> /dev/null > /tmp/$0$$

begin transaction;

create temp table excontitmp0 (
id_documento integer,
totale real
);

create temp table excontitmp1 (
id_documento integer,
totale real
);

create temp table excontitmp2 (
numerario integer
);

insert into excontitmp2 select numerario from conti_desc where
capoconto=$1 and sottoconto=$2;

insert into excontitmp0 select id_documento,
sum(importo) as totale from conti where capo_da=$1 and sotto_da=$2
and documenti.data>='01/01/2000' and
id_documento=documenti.id group by id_documento;

insert into excontitmp0 select id_documento,
-sum(importo) as totale from conti where capo_a=$1 and sotto_a=$2
and documenti.data>='01/01/2000' and
id_documento=documenti.id group by id_documento;

insert into excontitmp1 select id_documento, sum(totale)
as totale from excontitmp0 group by id_documento;

select id_documento, documenti.data, ditte.ragione_sociale,
totale*(1-excontitmp2.numerario*2) from
excontitmp1 where ditte.id=documenti.id_clifor and
documenti.id=id_documento order by documenti.data, id_documento;

select sum(totale*(1-excontitmp2.numerario*2)) as totale from excontitmp0;

commit transaction;

EOF

less /tmp/$0$$
rm /tmp/$0$$

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

Ciao,
AB