Re: 7.5 backend crash

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom Lane wrote:

| Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
|
|>kalman=# create table test ( a integer, b integer );
|>CREATE TABLE
|>kalman=# create table test1 ( c integer , d test );
|>CREATE TABLE
|
|
|>kalman=# alter table test drop column b;
|>ALTER TABLE <--- Here I think the server shall complain about
|
|
| Yeah, the design intention is that the ALTER should refuse to do it.
| Looks like I missed a case. Will fix, thanks for the report.

Hi,
in the mean time that you are working on it I believe that this is ugly too:

kalman=# create table test ( a integer );
CREATE TABLE
kalman=# alter table test add columb b test;
ALTER TABLE
kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null))))));
INSERT 33639 1
kalman=# select * from test;
~ a | b
- ---+----------------------------------------------------
~ 1 | (2,"(3,""(4,""""(5,""""""""(6,)"""""""")"""")"")")
(1 row)

The uglyness is on that series of '"'

why not the following result ?

kalman=# select * from test;
~ a | b
- ---+----------------------------------------------------
~ 1 | (2,(3,(4,(5,(6,)))))
(1 row)

Regards
Gaetano Mendola

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

iD8DBQFBBMRp7UpzwH2SGd4RAuV+AJsFBLv0pD8U9UaXQKwxnFvqSqWacACgzipD
0ZdJ2csaQ5kBEI3ADnMX4zk=
=iKgR
-----END PGP SIGNATURE-----