Problem: 32 Argument function parameter list

From: bradsnobar(at)netscape(dot)net (Bradley D(dot) Snobar)
To: pgsql-general(at)postgresql(dot)org
Subject: Problem: 32 Argument function parameter list
Date: 2005-01-31 04:06:03
Message-ID: 3FA831D5.3AFC72D2.0EA262E6@netscape.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I have posted this question to the wrong mailing list, I apologize (I am new to the postgres community) and I ask that someone please respond with the correct place to get my question answered.

I ran into a probelm during initdb after I tried to change the maximum number of functions in an argument list.

I'm not sure why I am getting this error message, and would be glad for any assistance.

This is the basic error message while running initdb after a recompile.
relnatts disagrees with indnatts for index

The exact message was
relnatts disagrees with indnatts for index 16678

More background information:

I'm trying to create a function (with pgsql) that has more than 32 arguments. My application design and database are correct. I really do have a requirement for a larger function call. I want to increase the maximum number of arguments that a function can take.

I tried to change this section of code to reflect my desire.
/usr/local/pgsql/include/server/pg_config_manual.h

#define INDEX_MAX_KEYS 32 /** change from 32 to 64 **/
#define FUNC_MAX_ARGS INDEX_MAX_KEYS

I then ran
make
make install

I then did an initdb which then ran for a little bit and eventually produced this error.

relnatts disagrees with indnatts for index 16678

Is there another constant that I need to change?

Thanks,
Brad

__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sven Willenberger 2005-01-31 04:09:47 Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings
Previous Message Lonni J Friedman 2005-01-31 02:50:35 Re: postgresql 7.4.6 slowing down