Re: 7.5 backend crash

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 7.5 backend crash
Date: 2004-07-26 22:06:49
Message-ID: 41058079.3040706@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Tom Lane wrote:
| Greg Stark <gsstark(at)mit(dot)edu> writes:
|
|>Gaetano Mendola <mendola(at)bigfoot(dot)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-----

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ian Barwick 2004-07-26 23:15:11 Unexpected subquery behaviour
Previous Message Tom Lane 2004-07-26 21:52:03 Re: WARNING: buffer refcount leak