Gaetano Mendola [EMAIL PROTECTED] writes:
I'm playing with complex row type:
...
kalman=# alter table test drop column b;
ALTER TABLE --- Here I think the server shall complain about
~ ( 7.4 doesn't complain neither )
Actually, on looking back at the
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,
-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
Gaetano Mendola [EMAIL PROTECTED] writes:
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)
Omg.
Greg Stark [EMAIL PROTECTED] writes:
Gaetano Mendola [EMAIL PROTECTED] writes:
kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null));
INSERT 33639 1
kalman=# select * from test;
~ a | b
---+
~ 1 |
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Greg Stark [EMAIL PROTECTED] writes:
|
|Gaetano Mendola [EMAIL PROTECTED] writes:
|
|kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null));
|INSERT 33639 1
|kalman=# select * from test;
|~ a | b
Gaetano Mendola [EMAIL PROTECTED] writes:
Tom Lane wrote:
| It shouldn't work --- the ALTER TABLE code should reject it. Looks like
| there are a few holes to be plugged here ...
The SQL standard forbid it ? I was believing that was a pretty cool feature!
:-)
I don't think we can support
-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