new rule syntax?

Поиск
Список
Период
Сортировка
От A. R. Van Hook
Тема new rule syntax?
Дата
Msg-id 43E5E8D2.6020502@lake-lotawana.mo.us
обсуждение исходный текст
Ответы Re: new rule syntax?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: new rule syntax?  ("Milen A. Radev" <milen@radev.net>)
Re: new rule syntax?  (Richard Huxton <dev@archonet.com>)
Список pgsql-sql
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
notnull)
 
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 finecreate 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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: UnixODBC-2.2.8-2.3.0 driver
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: new rule syntax?