| Lists: | pgsql-general |
|---|
| 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 |
| 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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | bradsnobar(at)netscape(dot)net (Bradley D(dot) Snobar) |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem: 32 Argument function parameter list |
| Date: | 2005-02-01 03:51:26 |
| Message-ID: | 9429.1107229886@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
bradsnobar(at)netscape(dot)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