Re: BUG #13762: server will crash after superuser alter function and set client_encoding

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: funnyxj(at)qq(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13762: server will crash after superuser alter function and set client_encoding
Date: 2015-11-09 14:45:54
Message-ID: 22805.1447080354@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

funnyxj(at)qq(dot)com writes:
> When superuser execute the following statements, the server will crash, it
> may be a bug.

> 1. alter function koi8r_to_utf8(integer, integer, cstring, internal,
> integer) set work_mem = default ;

That would be in the category of "don't do that". Encoding conversion
functions are invoked using special code paths that don't support every
possible option for functions, so I'm not too surprised that this breaks
things (and I see no reason to expend effort to try to make it not be
broken).

FWIW, I can't reproduce a crash with the described case either, so
I think there's probably some additional condition required. But
it doesn't really matter. Mucking with the properties of built-in
functions isn't considered a supported thing to do.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hiep Pham 2015-11-09 15:56:36 connect to C program
Previous Message Haribabu Kommi 2015-11-09 12:24:24 Re: BUG #13762: server will crash after superuser alter function and set client_encoding