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 C1AEED1C4CD
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Jul 2003 21:10:50 +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 71842-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Jul 2003 18:10:00 -0300 (ADT)
Received: from jal.clueinc.net (xd84b436b.ip.e-nt.net [216.75.67.107])
	by svr1.postgresql.org (Postfix) with ESMTP id 11C76D1C4BE
	for <pgsql-sql@postgresql.org>; Fri, 25 Jul 2003 18:10:45 -0300 (ADT)
Received: from jal.clueinc.net (localhost [127.0.0.1])
	by jal.clueinc.net (8.12.9/8.12.9/Debian-5) with ESMTP id
	h6PM8AA9017437
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL);
	Fri, 25 Jul 2003 17:08:11 -0500
Received: (from jal@localhost)
	by jal.clueinc.net (8.12.9/8.12.9/Debian-5) id h6PM8AxZ017435;
	Fri, 25 Jul 2003 17:08:10 -0500
Date: Fri, 25 Jul 2003 17:08:10 -0500
From: Jamie Lawrence <postgres@jal.org>
To: Tomasz Myrta <jasiek@klaster.net>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Odd problems with create rule
Message-ID: <20030725220810.GK1073@jal.clueinc.net>
Mail-Followup-To: Tomasz Myrta <jasiek@klaster.net>,
	pgsql-sql <pgsql-sql@postgresql.org>
References: <20030725213836.GJ1073@jal.clueinc.net>
	<3F219C59.2040807@klaster.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <3F219C59.2040807@klaster.net>
Organization: clue inc
X-URL: http://www.clueinc.net/
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/393
X-Sequence-Number: 14507

On Fri, 25 Jul 2003, Tomasz Myrta wrote:

> Dnia 2003-07-25 23:38, U?ytkownik Jamie Lawrence napisa?:
> >dlm(#                 values (
> >dlm(#                         new.projects._id,
>                                 ^^^^^^^^^^^^^^^^^
> >dlm(#                         new.doc_num,
> >dlm(#                         new.description,
> >dlm(#                         new.date,
> >dlm(#                         new.people_id,
> >dlm(#                         new.parent,
> >dlm(#                         new.document_type,
> >dlm(#                         new.state,
> >dlm(#                         new.machines_id,
> >dlm(#                         new.phases_id );
> >ERROR:  Namespace "*NEW*" does not exist
> >dlm=# 
> 
> Too many dots?
> Shouldn't it be "new.project_id"?

Oh, god. I'm a moron, or at least should have my vision checked.

Thank you.

-j

> Regards,
> Tomasz Myrta


-- 
Jamie Lawrence                                        jal@jal.org
Americans will tolerate just about anything as long as you 
don't stop traffic.
   - Dan Rather