Search Postgresql Archives

Problem: 32 Argument function parameter list

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux