Re: [HACKERS] wrong sql statement crashes backend

2007-06-17 Thread Jaime Casanova
On 6/17/07, Andrew Dunstan <[EMAIL PROTECTED]> wrote: Pavel Stehule wrote: >> >> Please don't send HTML-only email :-( > > I am sorry. It's stupid web mail. I didn't know so my messages was in > html format. > > Actually, it looks to me like it was sent as plain text encoded as base64. I got:

Re: [HACKERS] wrong sql statement crashes backend

2007-06-17 Thread Andrew Dunstan
Pavel Stehule wrote: Please don't send HTML-only email :-( I am sorry. It's stupid web mail. I didn't know so my messages was in html format. Actually, it looks to me like it was sent as plain text encoded as base64. I got: Content-Type: text/plain; charset=UTF-8; format=flowed Conten

Re: [HACKERS] wrong sql statement crashes backend

2007-06-17 Thread Pavel Stehule
Please don't send HTML-only email :-( I am sorry. It's stupid web mail. I didn't know so my messages was in html format. Anyway, seems I broke this a couple months ago. Fixed, thanks for the report. regards, tom lane ---(end of broadcast)-

Re: [HACKERS] wrong sql statement crashes backend

2007-06-17 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > SGVsbG8KCkkgZm91bmQgc2ltcGx5IGZ1bmN0aW9uIHdoaWNoIGlzIGJ1Z2d5 > LCBidXQgaXQgY3Jhc2hlcyBzZXJ2ZXIKCkNSRUFURSBPUiBSRVBMQUNFIEZV > TkNUSU9OIHRlc3QoYW55YXJyYXkpClJFVFVSTlMgYW55YXJyYXkgQVMgJCQK > ICBTRUxFQ1QgJDFba107IC0tIGsgaXMgYnVnCiQkIExBTkdVQUdFIHNxbDsK > .

[HACKERS] wrong sql statement crashes backend

2007-06-17 Thread Pavel Stehule
Hello I found simply function which is buggy, but it crashes server CREATE OR REPLACE FUNCTION test(anyarray) RETURNS anyarray AS $$ SELECT $1[k]; -- k is bug $$ LANGUAGE sql; SELECT test(array[10,2,3]); Correct function works well. Regards Pavel Stehule Output: postgres=# select version();