Problem: 32 Argument function parameter list

Started by Brad Snobarabout 21 years ago2 messagesgeneral
Jump to latest
#1Brad Snobar
bradsnobar@netscape.net

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Brad Snobar (#1)
Re: Problem: 32 Argument function parameter list

bradsnobar@netscape.net (Bradley D. Snobar) writes:

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

Did you do a *full* recompile afterwards? (make distclean and start
again would be my advice)

regards, tom lane