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 83B4ACCCE9
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Jul 2003 16:39:06 +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 71721-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Jul 2003 16:39:38 +0000 (GMT)
Received: from davinci.ethosmedia.com (unknown [209.10.40.251])
	by svr1.postgresql.org (Postfix) with ESMTP id 52287CC00C
	for <pgsql-sql@postgresql.org>; Fri, 18 Jul 2003 13:39:05 -0300 (ADT)
Received: from [63.195.55.98] (HELO spooky)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2)
	with ESMTP id 3228807; Fri, 18 Jul 2003 09:39:53 -0700
Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: Terence Kearns <terencek@isd.canberra.edu.au>,
	Richard Huxton <dev@archonet.com>
Subject: Re: (trigger function) -> ERROR: NEW used in non-rule query
Date: Fri, 18 Jul 2003 09:38:25 -0700
User-Agent: KMail/1.4.3
Cc: Terence Kearns <terencek@isd.canberra.edu.au>,
	pgsql-sql@postgresql.org
References: <3F17AE38.5020302@cts.canberra.edu.au>
	<200307181003.42279.dev@archonet.com>
	<3F17BB5C.4020803@cts.canberra.edu.au>
In-Reply-To: <3F17BB5C.4020803@cts.canberra.edu.au>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200307180938.25262.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/257
X-Sequence-Number: 14371

Terence,

> Oh well, can't win them all :/

Nope.  I'll suggest that for the TODO list ... we already have several 
requests for added features for PL/pgSQL.   The problem is that we currently 
don't have a lead developer for PL/pgSQL, so the language has rather 
stagnated.

> 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?  (We want to enable triggers in PL/perl, but that functionality isn't 
coming until at least 7.5).

-- 
Josh Berkus
Aglio Database Solutions
San Francisco