CREATE FUNCTION [...] AS '' LANGUAGE 'sql' crashes backend

Started by PostgreSQL Bugs Listover 24 years ago2 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: CREATE FUNCTION [...] AS '' LANGUAGE 'sql' crashes backend

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