Re: Functions with more than 32 parameters - Mailing list pgsql-general

From Oisin Glynn
Subject Re: Functions with more than 32 parameters
Date
Msg-id 003101c50f28$f01e6740$0300a8c0@bowdoin
Whole thread Raw
In response to Functions with more than 32 parameters  ("Oisin Glynn" <me@oisinglynn.com>)
List pgsql-general
Any advice for an opensource newbie running on Windows 2000? How hard is it
to rebuild for windows? Any instructions? What compiler?

Oisin

----- Original Message -----
From: "Bradley D. Snobar" <bradsnobar@netscape.net>
To: ""Oisin Glynn"" <me@oisinglynn.com>
Sent: Wednesday, February 09, 2005 10:40 PM
Subject: RE: [GENERAL] Functions with more than 32 parameters


>I just had the same problem the other day.
>
> Change this file:
> ..../postgresql-8.0.0/src/include/pg_config_manual.h
>
> #define INDEX_MAX_KEYS          64   /*was 32 */
> #define FUNC_MAX_ARGS           INDEX_MAX_KEYS
>
> Recompile the server.
>
> make distclean
> ./configure
> make
> make install
>
> "Oisin Glynn" <me@oisinglynn.com> wrote:
>
>>Hi,
>>
>>I am trying to keep database access encapsulated in functions from an
>>insert
>>and update point of view so as all of the applications writing to the
>>database are using the same functions/statements.
>>
>>My problem is I was creating functions to do inserts/updates and now I
>>have
>>a table with more than 32 columns and the functions seem to only want to
>>have 32 parameters?
>>
>>Is there any way around this?
>>
>>I have used stored procedures in this way with Oracle/SQL server before.Or
>>is there another strategy I could use?
>>
>>I am using Windows 2000 Postgres 8.0.1 if it makes a difference
>>
>>Thanks in advance,
>>Oisin
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>>
>
> __________________________________________________________________
> 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
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.305 / Virus Database: 265.8.6 - Release Date: 2/7/2005
>
>


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Understanding EXPLAIN ANALYZE output
Next
From: Tom Lane
Date:
Subject: Re: Understanding EXPLAIN ANALYZE output