X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 30C629DC813
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun,  5 Feb 2006 08:01:10 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 95548-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun,  5 Feb 2006 08:01:12 -0400 (AST)
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id EEFAA9DC80D
	for <pgsql-sql@postgresql.org>; Sun,  5 Feb 2006 08:01:07 -0400 (AST)
Received: from laker.lake-lotawana.mo.us (unknown [70.237.187.111])
	by svr4.postgresql.org (Postfix) with ESMTP id B88DD5AF07A
	for <pgsql-sql@postgresql.org>; Sun,  5 Feb 2006 12:01:11 +0000 (GMT)
Received: from [192.168.1.2] (c-69-243-248-112.hsd1.mo.comcast.net
	[69.243.248.112])
	by laker.lake-lotawana.mo.us (8.12.8/8.12.8) with ESMTP id
	k15C0nM8028495
	for <pgsql-sql@postgresql.org>; Sun, 5 Feb 2006 06:01:09 -0600
Message-ID: <43E5E8D2.6020502@lake-lotawana.mo.us>
Date: Sun, 05 Feb 2006 06:00:18 -0600
From: "A. R. Van Hook" <hook@lake-lotawana.mo.us>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: new rule syntax?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0 required=5 tests=[none]
X-Spam-Score: 0
X-Spam-Level: 
X-Archive-Number: 200602/38
X-Sequence-Number: 24048

I have two tables defined as:
checks
        (ckid                int NOT null PRIMARY KEY,
         payto               text,
         notes               text,
         ckdate              date,
         printed             int  default 0,
         tdate               timestamp not null)
checkitems
        (item                int not null,
         ckid                int NOT null references checks,
         itemtype            int not null,
         amt                 numeric(7,3),
         primary key         (item, ckid))

in previous versions (<8.1) the following rule declaration seemed to 
work fine
 create rule checks_d0 as
     on delete to checks
        do delete from checkitems
           where ckid = checks.ckid;
in 8.1.2 I get

ERROR: missing FROM-clause entry from table "checks"

any idea?

-- 
Arthur R. Van Hook
      Mayor 
The City of Lake Lotawana

hook@lake-lotawana.mo.us

(816) 578-4704 - Home
(816) 578-4215 - City
(816) 564-0769 - Cell