-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola <[EMAIL PROTECTED]> 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-----
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
