Thread: 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
functionsis 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