BUG WITH CREATE FUNCTION....... 
Author Message
 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



Mon, 26 May 2003 18:08:45 GMT
 BUG WITH CREATE FUNCTION.......

Quote:

>  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



Tue, 27 May 2003 04:07:17 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Trapping function keys(creating custom functions)!

2. Mixed case function or How to create user defined function

3. Creating SQL Server internal functions / functions

4. BUGS idapi BUGS idapi BUGS idapi BUGS

5. create operator vs create function

6. BUGS BUGS BUGS (Disappointed with Borland!)

7. WAS BUG, BUG, BUG

8. BUG BUG BUG: VB5+DAO 3.51

9. Bugs, Bugs, Bugs ...

10. user_name function "bug"

11. function error/bug

12. Restore bug using external functions?


 
Powered by phpBB® Forum Software