pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Increasing MAX_ARGS
12+ messages / 5 participants
[nested] [flat]

* Re: Increasing MAX_ARGS
@ 2001-11-07 01:34 Josh Berkus <josh@agliodbs.com>
  2001-11-07 02:11 ` Re: Increasing MAX_ARGS Bruce Momjian <pgman@candle.pha.pa.us>
  2001-11-07 04:43 ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 12+ messages in thread

From: Josh Berkus @ 2001-11-07 01:34 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql

Tom,

> src/include.
> 
> If you haven't run configure yet, do that first.

OK.  
1. I modified /src/include/config.h.in
2. I configured postgres.  Config.h correctly shows MAX_ARGS at 32.
3. I built postgres
4. I initdb'd.

As a test, I tried building a function with 20 parameters in Template1.
I got:

"ERROR: Procedures cannot take more than 16 arguments."

What's going on here?  Is there a check for the number of arguments
outside of the compile configuration?

-Josh




______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
@ 2001-11-07 02:11 ` Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 0 replies; 12+ messages in thread

From: Bruce Momjian @ 2001-11-07 02:11 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql

> Tom,
> 
> > src/include.
> > 
> > If you haven't run configure yet, do that first.
> 
> OK.  
> 1. I modified /src/include/config.h.in
> 2. I configured postgres.  Config.h correctly shows MAX_ARGS at 32.
> 3. I built postgres
> 4. I initdb'd.
> 
> As a test, I tried building a function with 20 parameters in Template1.
> I got:
> 
> "ERROR: Procedures cannot take more than 16 arguments."
> 
> What's going on here?  Is there a check for the number of arguments
> outside of the compile configuration?

That should work. The strange part is that I can't find that error
message anywhere in the sources.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
@ 2001-11-07 04:43 ` Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 05:42   ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 1 reply; 12+ messages in thread

From: Tom Lane @ 2001-11-07 04:43 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-sql

"Josh Berkus" <josh@agliodbs.com> writes:
> As a test, I tried building a function with 20 parameters in Template1.
> I got:

> "ERROR: Procedures cannot take more than 16 arguments."

Get out your debugger and find where that's coming from.  We might have
missed someplace that should be using the FUNC_MAX_ARGS symbol instead
of a hardwired constant (though I thought we'd fixed them all the last
time round...)

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-07 04:43 ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-07 05:42   ` Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 06:12     ` Re: Increasing MAX_ARGS Bruce Momjian <pgman@candle.pha.pa.us>
  2001-11-07 16:30     ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 12+ messages in thread

From: Tom Lane @ 2001-11-07 05:42 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; pgsql-sql

> "Josh Berkus" <josh@agliodbs.com> writes:
>> "ERROR: Procedures cannot take more than 16 arguments."

FWIW, I cannot find any such message string in current sources, nor 7.1,
7.0, or 6.5 sources.  I think this must be coming from some non-Postgres
frontend code.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-07 04:43 ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 05:42   ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-07 06:12     ` Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 0 replies; 12+ messages in thread

From: Bruce Momjian @ 2001-11-07 06:12 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Josh Berkus <josh@agliodbs.com>; pgsql-sql

> > "Josh Berkus" <josh@agliodbs.com> writes:
> >> "ERROR: Procedures cannot take more than 16 arguments."
> 
> FWIW, I cannot find any such message string in current sources, nor 7.1,
> 7.0, or 6.5 sources.  I think this must be coming from some non-Postgres
> frontend code.

The current message is:

	ERROR: function cannot take more than 16 arguments.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-07 04:43 ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 05:42   ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-07 16:30     ` Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 16:35       ` Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-08 16:34       ` Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  1 sibling, 2 replies; 12+ messages in thread

From: Tom Lane @ 2001-11-07 16:30 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; pgsql-sql

>> "Josh Berkus" <josh@agliodbs.com> writes:
> "ERROR: Procedures cannot take more than 16 arguments."

> FWIW, I cannot find any such message string in current sources,

Sigh, I was certainly not firing on all cylinders last night.
That *is* the spelling of the message in 7.1 and before --- see
catalog/pg_proc.c.  Are you certain that you recompiled with the new
setting of FUNC_MAX_ARGS?  Unless you did configure --enable-depend,
config.h changes generally require "make clean" before "make all" to
ensure that the changes propagate.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-07 04:43 ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 05:42   ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 16:30     ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-07 16:35       ` Josh Berkus <josh@agliodbs.com>
  1 sibling, 0 replies; 12+ messages in thread

From: Josh Berkus @ 2001-11-07 16:35 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; Josh Berkus <josh@agliodbs.com>; pgsql-sql

Tom,

> Sigh, I was certainly not firing on all cylinders last night.

Well, that's what you get for doing e-mail until midnight.  :-P

> That *is* the spelling of the message in 7.1 and before --- see
> catalog/pg_proc.c.  Are you certain that you recompiled with the new
> setting of FUNC_MAX_ARGS?  Unless you did configure --enable-depend,
> config.h changes generally require "make clean" before "make all" to
> ensure that the changes propagate.

That would be the problem, then.  I didn't know about the "make clean"
or the "--enable-depend".  Like I said, I'm strictly high-level
languages ...

I'll re-compile as soon as I finish helping my client with the current
network emergency, and report back.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-07 04:43 ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 05:42   ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 16:30     ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-08 16:34       ` Josh Berkus <josh@agliodbs.com>
  2001-11-09 00:48         ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 1 reply; 12+ messages in thread

From: Josh Berkus @ 2001-11-08 16:34 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; Josh Berkus <josh@agliodbs.com>; pgsql-sql

Tom,

> Sigh, I was certainly not firing on all cylinders last night.
> That *is* the spelling of the message in 7.1 and before --- see
> catalog/pg_proc.c.  Are you certain that you recompiled with the new
> setting of FUNC_MAX_ARGS?  Unless you did configure --enable-depend,
> config.h changes generally require "make clean" before "make all" to
> ensure that the changes propagate.

Darn.  And I just noticed that 7.2b2 is out.  I guess I'll have to try
the configuration with both versions of Postgrsql.  Any pitfalls in
having 2 versions installed?

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-07 04:43 ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 05:42   ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 16:30     ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-08 16:34       ` Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
@ 2001-11-09 00:48         ` Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-09 05:35           ` Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 12+ messages in thread

From: Tom Lane @ 2001-11-09 00:48 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-sql

"Josh Berkus" <josh@agliodbs.com> writes:
> Any pitfalls in
> having 2 versions installed?

Give them different install directories, data directories, and port
numbers, and you're good to go --- I run multiple versions routinely.

The --with-pgport and --prefix configure options make it easy to set
up a test version with nonstandard directories and port.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-07 04:43 ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 05:42   ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 16:30     ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-08 16:34       ` Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-09 00:48         ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-09 05:35           ` Josh Berkus <josh@agliodbs.com>
  2001-11-09 15:58             ` Re: Increasing MAX_ARGS Roberto Mello <rmello@cc.usu.edu>
  0 siblings, 1 reply; 12+ messages in thread

From: Josh Berkus @ 2001-11-09 05:35 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql

Tom, Bruce, Roberto,

Ok, it worked!

I have my first function (a test function, mind you) with 20 parameters.  

To compile and install postgres, I did both ./configure --enable-depend
and make clean.

BTW, pg_dumpall is working beautifully now.  I was able to back up the
server, install the new version, and restore the server ... all in about
15 minutes, from a remote console.  Try to do that with MS SQL Server!

-Josh

P.S. Thank you for your help!

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-07 04:43 ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 05:42   ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 16:30     ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-08 16:34       ` Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-09 00:48         ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-09 05:35           ` Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
@ 2001-11-09 15:58             ` Roberto Mello <rmello@cc.usu.edu>
  2001-11-11 15:39               ` Re: Increasing MAX_ARGS Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 12+ messages in thread

From: Roberto Mello @ 2001-11-09 15:58 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql

On Thu, Nov 08, 2001 at 09:35:49PM -0800, Josh Berkus wrote:
> Tom, Bruce, Roberto,
> 
> Ok, it worked!
> 
> I have my first function (a test function, mind you) with 20 parameters.  

That's great Josh!
 
> To compile and install postgres, I did both ./configure --enable-depend
> and make clean.

I think the make clean takes care of enabling dependencies, so the
--enable-depend would be redundant (/me thinks).

I usually rm the config.cache just to be safe.

> BTW, pg_dumpall is working beautifully now.  I was able to back up the
> server, install the new version, and restore the server ... all in about
> 15 minutes, from a remote console.  Try to do that with MS SQL Server!

Heheh. PostgreSQL rocks! :-)

-Roberto

-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
$$$ not found --  A)bort, R)efinance, D)eclare bankruptcy



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Increasing MAX_ARGS
  2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-07 04:43 ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 05:42   ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-07 16:30     ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-08 16:34       ` Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-09 00:48         ` Re: Increasing MAX_ARGS Tom Lane <tgl@sss.pgh.pa.us>
  2001-11-09 05:35           ` Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
  2001-11-09 15:58             ` Re: Increasing MAX_ARGS Roberto Mello <rmello@cc.usu.edu>
@ 2001-11-11 15:39               ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 12+ messages in thread

From: Peter Eisentraut @ 2001-11-11 15:39 UTC (permalink / raw)
  To: Roberto Mello <rmello@cc.usu.edu>; +Cc: Josh Berkus <josh@agliodbs.com>; Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql

Roberto Mello writes:

> > To compile and install postgres, I did both ./configure --enable-depend
> > and make clean.
>
> I think the make clean takes care of enabling dependencies, so the
> --enable-depend would be redundant (/me thinks).

No, make clean removes the dependency information.  What --enable-depend
does is to compute the dependencies of *.o files while the file is
compiled the first time.  Then, if you change one of the dependencies and
run make a second time, it will notice the changed dependencies and
recompile.  (Otherwise, nothing might happen or only a subset of the files
will be recompiled, one of which happened to Josh.)  Theoretically, this
should be the default, but it makes the build rather slow and most people
don't need it.

-- 
Peter Eisentraut   peter_e@gmx.net




^ permalink  raw  reply  [nested|flat] 12+ messages in thread


end of thread, other threads:[~2001-11-11 15:39 UTC | newest]

Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-11-07 01:34 Re: Increasing MAX_ARGS Josh Berkus <josh@agliodbs.com>
2001-11-07 02:11 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-11-07 04:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-07 05:42   ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-07 06:12     ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-11-07 16:30     ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-07 16:35       ` Josh Berkus <josh@agliodbs.com>
2001-11-08 16:34       ` Josh Berkus <josh@agliodbs.com>
2001-11-09 00:48         ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-09 05:35           ` Josh Berkus <josh@agliodbs.com>
2001-11-09 15:58             ` Roberto Mello <rmello@cc.usu.edu>
2001-11-11 15:39               ` Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox