Postgres Pro
Downloads
Home   >   mailing lists

INDEX_MAX_KEYS too small, need 36 parameters - Mailing list pgsql-bugs

From Hans Schou
Subject INDEX_MAX_KEYS too small, need 36 parameters
Date
Msg-id Pine.LNX.4.50.0407242236370.26855-100000@figus.w0.dk
Whole thread Raw
Responses Re: INDEX_MAX_KEYS too small, need 36 parameters  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Tree view 
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        :    Hans Schou
Your email address    :    chlor@schou.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

pgsql-bugs by date:

Previous
From: "Mason"
Date:
Subject: Strange AFTER UPDATE trigger behavior
Next
From: Kris Jurka
Date:
Subject: 7.5dev assertion failure w/ v3 protocol and transactions