Hi,

My pgsql an postgres ( version V 7.0.2 ) stop with an error when i write 
the following query under pgsql :

 create function test(text) returns text AS '' LANGUAGE 'sql';

ERROR under pgsql :

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.


Error under postmaster :

ERROR:  ProcedureCreate: procedure toto already exists with same arguments
Server process (pid 21532) exited with status 11 at Thu Dec  7 10:55:08 2000
Terminating any active server processes...
Server processes were terminated at Thu Dec  7 10:55:08 2000
Reinitializing shared memory and semaphores
The Data Base System is starting up
DEBUG:  Data Base System is starting up at Thu Dec  7 10:55:08 2000
DEBUG:  Data Base System was interrupted being in production at Thu Dec  7 10:38:10 2000
DEBUG:  Data Base System is in production state at Thu Dec  7 10:55:08 2000


Regards

PEJAC Pascal


Thu, 7 Dec 2000 11:06:16 +0100 (CET)
<pejac@altern.org>
BUG WITH CREATE FUNCTION.......
<pejac@altern.org> writes:
>  create function test(text) returns text AS '' LANGUAGE 'sql';
>  [crashes]

OK, now it says:

regression=# create function test(text) returns text AS '' LANGUAGE 'sql';
ERROR:  function declared to return text, but no SELECT provided

Thanks for the report!

			regards, tom lane

Thu, 07 Dec 2000 14:42:08 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG WITH CREATE FUNCTION....... 