Re: Functions with more than 32 parameters
От | Oisin Glynn |
---|---|
Тема | Re: Functions with more than 32 parameters |
Дата | |
Msg-id | 003101c50f28$f01e6740$0300a8c0@bowdoin обсуждение исходный текст |
Ответ на | Functions with more than 32 parameters ("Oisin Glynn" <me@oisinglynn.com>) |
Список | 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 по дате отправления: