Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group