Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 4B27A9FB34E for ; Thu, 4 Oct 2007 10:01:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 36527-04 for ; Thu, 4 Oct 2007 10:00:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by postgresql.org (Postfix) with ESMTP id 4872A9FB335 for ; Thu, 4 Oct 2007 10:00:43 -0300 (ADT) Received: from [194.25.154.138] (helo=webserv.wug.de) by mrelayeu.kundenserver.de (node=mrelayeu7) with ESMTP (Nemesis) id 0ML2xA-1IdQJI14BE-0002Pl; Thu, 04 Oct 2007 15:00:16 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1IdQJH-0007jk-00 for pgsql-sql@postgresql.org; Thu, 04 Oct 2007 15:00:11 +0200 Date: Thu, 4 Oct 2007 15:00:11 +0200 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Rule Error Message-ID: <20071004130011.GH15428@a-kretschmer.de> References: <008f01c80678$de562990$6f00a8c0@hengky> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <008f01c80678$de562990$6f00a8c0@hengky> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX18zer5XuSceSh5fx+sbSVGf2PZrEXX/Fv4PaN9 fBUft2/Mfbb5yun7S4XIedm93D3rEt6hO2+Y89SCVk53EAwecm TZYg3uidjTpaa0glJAR+X5G0deBtkvR X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/24 X-Sequence-Number: 29396 am Thu, dem 04.10.2007, um 19:22:32 +0800 mailte Hengky Lie folgendes: > CREATE RULE "rule1" AS ON INSERT TO "public"."tblmasdbt" > > DO (insert into tblmasgl (KODEGL,NAMAREK) VALUES (new.KODEGL, new.NAMAREK)); > > > > But I always get this error : > > > ERROR: column "kodegl" of relation "tblmasgl" does not exist > > > Here is the Table Structure > > CREATE TABLE "public"."tblmasgl" ( > > "KODEGL" VARCHAR(15) NOT NULL, Okay, you need to quote the column-name with " since they are in uppercase. DO (insert into tblmasgl ("KODEGL","NAMAREK") and maybe also new."KODEGL" and new."NAMAREK". Try it and tell if you have success. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net