-----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-----
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
