-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola <mendola@bigfoot.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-----