possible bug in CREATE FUNCTION

From: Michel Decima <michel(dot)decima(at)rd(dot)francetelecom(dot)fr>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: possible bug in CREATE FUNCTION
Date: 2000-10-26 14:18:10
Message-ID: 19340920074954.12524@p-grive.issy.cnet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hello everybody,

I was trying playing with the CREATE FUNCTION statement in psql when I made
a copy/paste mistake : the function body was empty. The error message was
strange:

guanabara:~> psql
Password:
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

decimami=# CREATE FUNCTION foo() RETURNS text 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.
!#

Is this a feature ? An error message like 'function body empty' wouldn't be
better ?

MD.

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2000-10-26 15:00:24 Re: [SQL] pg_atoi: error in "template1": can't parse "template1"
Previous Message Dronamraju Rajesh 2000-10-26 12:17:47 pg_atoi: error in "template1": can't parse "template1"