CREATE FUNCTION [...] AS '' LANGUAGE 'sql' crashes backend
Tim Landscheidt (tim.landscheidt@gmx.de) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
CREATE FUNCTION [...] AS '' LANGUAGE 'sql' crashes backend
Long Description
Using "PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96" on Red Hat 7.1 (postgresql-server-7.0.3-8.i386.rpm), an empty function definition crashes the backend. Obviously, defining empty functions is a quite obscure passion in the first place, but PostgreSQL could be a little more polite telling that.
Sample Code
CREATE FUNCTION blah_blah (INT) RETURNS INT AS '' LANGUAGE 'sql';
< pqReadData() -- backend closed the channel unexpectedly.
< This probably means the backend terminated abnormally
< before or while processing the request.
< The connection to the server was lost. Attempting reset: Failed.
No file was uploaded with this report
pgsql-bugs@postgresql.org writes:
CREATE FUNCTION [...] AS '' LANGUAGE 'sql' crashes backend
7.1 does this:
regression=# CREATE FUNCTION blah_blah (INT) RETURNS INT AS '' LANGUAGE 'sql';
ERROR: function declared to return integer, but no SELECT provided
regards, tom lane