Skip site navigation (1) Skip section navigation (2)

7.5 backend crash

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: 7.5 backend crash
Date: 2004-07-26 00:44:56
Message-ID: 41045408.2010504@bigfoot.com (view raw or flat)
Thread:
Lists: 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-----


Responses

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2004-07-26 01:12:52
Subject: Re: Planning for beta (was Re: Sketch of extending error
Previous:From: Bruce MomjianDate: 2004-07-26 00:29:40
Subject: Re: Planning for beta (was Re: Sketch of extending error handling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group