BUG WITH CREATE FUNCTION.......

Started by Nonameabout 25 years ago2 messages
#1Noname
pejac@altern.org

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: 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