Oisin
----- Original Message ----- From: "Bradley D. Snobar" <bradsnobar@xxxxxxxxxxxx>
To: ""Oisin Glynn"" <me@xxxxxxxxxxxxxx>
Sent: Wednesday, February 09, 2005 10:40 PM
Subject: RE: 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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx
__________________________________________________________________
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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
