Обсуждение: Problem: 32 Argument function parameter list

Поиск
Список
Период
Сортировка

Problem: 32 Argument function parameter list

От
bradsnobar@netscape.net (Bradley D. Snobar)
Дата:
If I have posted this question to the wrong mailing list, I apologize (I am new to the postgres community) and I ask
thatsomeone 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
thata 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

Re: Problem: 32 Argument function parameter list

От
Tom Lane
Дата:
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