Re: 7.5 backend crash - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: 7.5 backend crash
Date
Msg-id 41058079.3040706@bigfoot.com
Whole thread Raw
In response to Re: 7.5 backend crash  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 7.5 backend crash  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom Lane wrote:
| Greg Stark <gsstark@mit.edu> writes:
|
|>Gaetano Mendola <mendola@bigfoot.com> 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.....
|
|
|>This is pretty cool and frankly amazing that it works.
|
|
| 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!
:-)


Regards
Gaetano Mendola

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

iD8DBQFBBYB47UpzwH2SGd4RAoyfAJ9B5AIHC8A8nyWLOt+Xw6GXJa3kFACgxkzu
kBxnvugWhzjNvc+UboAwAjE=
=xEBD
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WARNING: buffer refcount leak
Next
From: Ian Barwick
Date:
Subject: Unexpected subquery behaviour