X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.225.181])
	by svr1.postgresql.org (Postfix) with ESMTP id 7F6FFCCC4E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Jul 2003 23:12:56 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new,
	port 10024) with ESMTP id 84399-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Jul 2003 23:13:16 +0000 (GMT)
Received: from mail.messagingengine.com (out2.smtp.messagingengine.com
	[66.111.4.26])
	by svr1.postgresql.org (Postfix) with ESMTP id 560A9CBA17
	for <pgsql-sql@postgresql.org>; Fri, 18 Jul 2003 20:12:44 -0300 (ADT)
Received: from mail.messagingengine.com (localhost [127.0.0.1])
	by localhost.localdomain (Postfix) with ESMTP
	id E90213EE9C; Fri, 18 Jul 2003 19:13:17 -0400 (EDT)
Received: from 10.202.2.150 ([10.202.2.150] helo=mail.messagingengine.com) by
	messagingengine.com with SMTP; Fri, 18 Jul 2003 19:13:17 -0400
X-Epoch: 1058569997
X-Sasl-enc: kM/89O56ywUj1jC2XYMAQA
Received: from cts.canberra.edu.au (shorty.menu80.com [203.37.117.98])
	by www.fastmail.fm (Postfix) with ESMTP
	id B48123EE36; Fri, 18 Jul 2003 19:13:13 -0400 (EDT)
Message-ID: <3F187F0C.4000403@cts.canberra.edu.au>
Date: Sat, 19 Jul 2003 09:13:16 +1000
From: Terence Kearns <terencek@cts.canberra.edu.au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.3.1) Gecko/20030425
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Josh Berkus <josh@agliodbs.com>
Cc: 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/289
X-Sequence-Number: 14403

Josh Berkus wrote:
> 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 beggers can't be choosers. I find it entirely amazing that one has 
access to such a capable product entirely free of charge :)

While people like myself may raise issues from time to time and 
sometimes express frustration, it doesn't mean that we don't think that 
postgres (and associated tools) is absolutely awsome. I'm more than 
content to "make do" ;^) with what postgres has now.

> 
>>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).
> 


Let's just say I don't belong to the very large community who LOVE the 
language. Don't get too excited, it's just my personal preference. I 
don't find the language "easy" at all (which is how it is towted).

One of these days when I get "spare time" (and the moon is blue), then I 
will hit it again and maybe do it justice in terms of effort.