Обсуждение: BUG WITH CREATE FUNCTION.......

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

<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