7.5 backend crash - Mailing list pgsql-hackers

From Gaetano Mendola
Subject 7.5 backend crash
Date
Msg-id 41045408.2010504@bigfoot.com
Whole thread Raw
Responses Re: 7.5 backend crash  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: 7.5 backend crash  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,
I'm playing with complex row type:


kalman=# create table test ( a integer, b integer );
CREATE TABLE
kalman=# create table test1 ( c integer , d test );
CREATE TABLE
kalman=# insert into test1 values ( 1, (2,3) );
INSERT 17277 1
kalman=# select * from test1;
~ c |   d
- ---+-------
~ 1 | (2,3)
(1 row)

kalman=# alter table test drop column b;
ALTER TABLE        <--- Here I think the server shall complain about
~                             ( 7.4 doesn't complain neither )

the following select on table test1 will crash the back end

kalman=# select * from test1;
server closed the connection unexpectedly
~        This probably means the server terminated abnormally
~        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>




Regards
Gaetano Mendola



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBBFQH7UpzwH2SGd4RAvIXAJ0bcfGdP5sfPFRYdfKOJ0YchRYXPgCfZti7
wKfzG4GwdFft0a1LDXK9fmo=
=wjvZ
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Planning for beta (was Re: Sketch of extending error
Next
From: Gaetano Mendola
Date:
Subject: Re: 7.5 release notes