From: | Hans Schou <chlor(at)schou(dot)dk> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | INDEX_MAX_KEYS too small, need 36 parameters |
Date: | 2004-07-24 20:40:00 |
Message-ID: | Pine.LNX.4.50.0407242236370.26855-100000@figus.w0.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Hans Schou
Your email address : chlor(at)schou(dot)dk
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.4.18) : Linux 2.4.19-36mdk
PostgreSQL version (example: PostgreSQL-7.4.3): PostgreSQL-7.4.3
Compiler used (example: gcc 2.95.2) : gcc 3.2
Please enter a FULL description of your problem:
------------------------------------------------
I needed to have 36 function parameters.
PostgreSQL only allows 32.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
create function addhit(
text,text,text,text,text,
text,text,text,text,text,
text,text,text,text,text,
text,text,text,text,text,
text,text,text,text,text,
text,text,text,text,text,
text,text,text,text,text,
text
) returns int4 as '
.....
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
--- src/include/pg_config_manual.h.orig 2004-07-24 22:13:53.000000000 +0200
+++ src/include/pg_config_manual.h 2004-07-24 22:14:02.000000000 +0200
@@ -53,7 +53,7 @@
*
* Changing these requires an initdb.
*/
-#define INDEX_MAX_KEYS 32
+#define INDEX_MAX_KEYS 64
#define FUNC_MAX_ARGS INDEX_MAX_KEYS
/*
--
Hamletsgade 4 - 201, DK-2200 København N, Phone: +45 3582 9079
Schou Industries ApS http://schou.dk/ CVR: 26 13 44 39
--------------------------------------------------------------
"Why would you hand...our IP to America gift-wrapped, without
any return?" -- Andrew Tridgell, software patents
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 2004-07-26 11:18:52 | Re: ecpg -D SYMBOL |
Previous Message | Alexander M. Pravking | 2004-07-23 22:07:18 | Re: Function does not see relations within schema it belongs to? |