Missing RULEs from VIEWs and their format

Поиск
Список
Период
Сортировка
От Erwin Brandstetter
Тема Missing RULEs from VIEWs and their format
Дата
Msg-id 4BBCC520.4070400@falter.at
обсуждение исходный текст
Ответы Re: Missing RULEs from VIEWs and their format  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-hackers
Hi developers!

I have just filed ticket #167 concerning missing RULEs with VIEWs.
On a related but less important note: the formatting of rules might be
improved if was done like triggers are:

-- status quo
CREATE OR REPLACE RULE on_delete AS
     ON DELETE TO test DO INSTEAD  DELETE FROM test2
   WHERE test2.id = old.id;

-- proposal
CREATE OR REPLACE RULE on_delete AS
   ON DELETE
   TO test
   DO INSTEAD
   DELETE FROM test2
    WHERE test2.id = old.id;

Regards
Erwin

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

Предыдущее
От: "pgAdmin Trac"
Дата:
Сообщение: [pgAdmin III] #167: Missing RULEs for VIEWs in SQL pane
Следующее
От: Thom Brown
Дата:
Сообщение: Feature request: limited deletions