Re: rules over multiple tables - Mailing list pgsql-novice

From Daniel Grob
Subject Re: rules over multiple tables
Date
Msg-id 23927.1016806662@www53.gmx.net
Whole thread Raw
In response to Re: rules over multiple tables  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: rules over multiple tables
List pgsql-novice
Hi all,

I'm now upgrading to Version 7.2.

Here's already the Syntax that dosn't work:

create function
delete_irgendwas_function

(int4,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,text,text,text,text,text,text,text,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,int4,varchar,date,time,varchar,varchar,text,varchar,varchar,int4,varchar,int4,varchar,varchar,varchar,varchar,varchar,varchar,varchar,date,varchar)
returns boolean as '
declare
"ID_ADDR" alias for $1;
"COMPANY" alias for $2;
...
"SIGN" alias for $65;
begin
delete from "ADDRESSES"
where "ID_ADDR" = f_"ID_ADDR" AND "COMPANY" = f_"COMPANY" ...;
delete from "CONTACTS"
where "ID" = f_"ID" AND "C_CATEGORY" = f_"C_CATEGORY" ...;
return 1;
END;'
LANGUAGE 'internal';
ERROR:  Procedures cannot take more than 16 arguments

I tried to change MAX_ARGS in /src/include/config.h.in but it dosn't work
(compilation failed, unknown attribute).

Has anyone another Idea how to delete (and update) over two tables?

--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net


pgsql-novice by date:

Previous
From: "Al-Haddad, Mohammad J"
Date:
Subject: configuration
Next
From: Tom Lane
Date:
Subject: Re: rules over multiple tables