X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id E25BED1C512
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  1 Aug 2003 20:13:13 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 68074-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  1 Aug 2003 17:12:06 -0300 (ADT)
Received: from mail.ward.six (unknown [212.57.173.151])
	by svr1.postgresql.org (Postfix) with ESMTP id 27B89D1C4BD
	for <pgsql-sql@postgresql.org>; Fri,  1 Aug 2003 17:13:09 -0300 (ADT)
Date: Sat, 2 Aug 2003 02:12:57 +0600
From: Denis Zaitsev <zzz@anda.ru>
To: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: NEW and a subselect in a rule
Message-ID: <20030802021257.A2581@natasha.ward.six>
References: <3F28CC86.B82994F3@rodos.fzk.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <3F28CC86.B82994F3@rodos.fzk.de>;
	from ch@rodos.fzk.de on Thu, Jul 31, 2003 at 10:00:07AM +0200
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/13
X-Sequence-Number: 14629

On Thu, Jul 31, 2003 at 10:00:07AM +0200, Christoph Haller wrote:
> >
> > So, I met such a problem: it's impossible to use NEW in a subselect
> > used in a (non-select) rule.  The error is: <Relation "*NEW*" does not
> 
> > exist>.  Is this a way to do that newertheless (without using of a
> > function, of course)?
> >
> Could we see the CREATE RULE command causing the error?

I've sent the other message (with the Subject: Nonexistent NEW
relation...) into the list.  The code is there.  The problem is
already closed (not solved!).  Thanks anyway.