X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.192])
	by svr1.postgresql.org (Postfix) with ESMTP id B2C67CCD78
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Jul 2003 16:48:25 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new,
	port 10024) with ESMTP id 70124-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Jul 2003 16:48:55 +0000 (GMT)
Received: from exchange.hq.openratings.com (unknown [141.149.165.226])
	by svr1.postgresql.org (Postfix) with ESMTP id 9C994CCD6F
	for <pgsql-sql@postgresql.org>; Fri, 18 Jul 2003 13:48:22 -0300 (ADT)
Received: from openratings.com (cancun.hq.openratings.com [10.0.0.225]) by
	exchange.hq.openratings.com with SMTP (Microsoft Exchange
	Internet Mail Service Version 5.5.2653.13)
	id 38QM4849; Fri, 18 Jul 2003 12:48:53 -0400
Message-ID: <3F18250E.7090001@openratings.com>
Date: Fri, 18 Jul 2003 12:49:18 -0400
From: Dmitry Tkach <dmitry@openratings.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Josh Berkus <josh@agliodbs.com>
Cc: Terence Kearns <terencek@isd.canberra.edu.au>,
	Richard Huxton <dev@archonet.com>, pgsql-sql@postgresql.org
Subject: Re: (trigger function) -> ERROR: NEW used in non-rule query
References: <3F17AE38.5020302@cts.canberra.edu.au>
	<200307181003.42279.dev@archonet.com>
	<3F17BB5C.4020803@cts.canberra.edu.au>
	<200307180938.25262.josh@agliodbs.com>
In-Reply-To: <200307180938.25262.josh@agliodbs.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/258
X-Sequence-Number: 14372

Josh Berkus wrote:

>>Well I suppose I could try TCL. The problem is that there is little to
>>no documentation on postgres stored procedures in TCL and I've never
>>even seen the language before. None the less, I'll look into it. It's
>>almost worth it. If that fails, I may even try perl <shudders>.
>>    
>>
>
>And what's wrong with Perl?   Other than the inability to write triggers with 
>it? 
>
That's *exactly* "what's wrong" with it :-)
If I understand what he is talking about correctly, his whole problem is 
that he is writing a trigger :-)

Dima