Thread

1. CREATE FUNCTION

   Carmen Wai <wai_carmen@hotmail.com> — 2002-08-07T15:41:10Z

   Hello:
   
   I found that when I use CREATE FUNCTION in postgresql, the maximum number of 
   arguments is 16 only. How I config so that the CREATE FUNCTION allows 
   unlimited number of arguments?
   
   Thanks a lot!
   Carmen
   
   
   
   
   _________________________________________________________________
   Join the worlds largest e-mail service with MSN Hotmail. 
   http://www.hotmail.com
   
   
   

2. Re: CREATE FUNCTION

   Neil Conway <nconway@klamath.dyndns.org> — 2002-08-07T15:53:09Z

   "Carmen Wai" <wai_carmen@hotmail.com> writes:
   > I found that when I use CREATE FUNCTION in postgresql, the maximum
   > number of arguments is 16 only. How I config so that the CREATE
   > FUNCTION allows unlimited number of arguments?
   
   Change FUNC_MAX_ARGS in src/include/pg_config.h, 'make clean',
   recompile, re-install, and re-initdb.
   
   Cheers,
   
   Neil
   
   -- 
   Neil Conway <neilconway@rogers.com>
   PGP Key ID: DB3C29FC
   
   
   

3. Re: CREATE FUNCTION

   Richard Huxton <dev@archonet.com> — 2002-08-07T15:58:51Z

   On Wednesday 07 Aug 2002 4:41 pm, Carmen Wai wrote:
   > Hello:
   >
   > I found that when I use CREATE FUNCTION in postgresql, the maximum number
   > of arguments is 16 only. How I config so that the CREATE FUNCTION allows
   > unlimited number of arguments?
   
   Check the mailing archives - there's a constant in pg_config.h you'll need to 
   increase and then recompile. Don't forget to dump your database first for 
   backup.
   
   - Richard Huxton
   
   

4. Re: CREATE FUNCTION

   Gregory Seidman <gss+pg@cs.brown.edu> — 2002-08-08T00:28:42Z

   Neil Conway sez:
   } "Carmen Wai" <wai_carmen@hotmail.com> writes:
   } > I found that when I use CREATE FUNCTION in postgresql, the maximum
   } > number of arguments is 16 only. How I config so that the CREATE
   } > FUNCTION allows unlimited number of arguments?
   } 
   } Change FUNC_MAX_ARGS in src/include/pg_config.h, 'make clean',
   } recompile, re-install, and re-initdb.
   
   Is the initdb really necessary? Will the modified postmaster not work on
   the existing data directory?
   
   } Cheers,
   } Neil
   --Greg
   
   
   

5. Re: CREATE FUNCTION

   Tom Lane <tgl@sss.pgh.pa.us> — 2002-08-08T02:20:48Z

   Gregory Seidman <gss+pg@cs.brown.edu> writes:
   > Neil Conway sez:
   > } Change FUNC_MAX_ARGS in src/include/pg_config.h, 'make clean',
   > } recompile, re-install, and re-initdb.
   
   > Is the initdb really necessary?
   
   Yes.
   
   			regards, tom lane