Missing RULEs from VIEWs and their format - Mailing list pgadmin-hackers

From Erwin Brandstetter
Subject Missing RULEs from VIEWs and their format
Date
Msg-id 4BBCC520.4070400@falter.at
Whole thread Raw
Responses Re: Missing RULEs from VIEWs and their format  (Guillaume Lelarge <guillaume@lelarge.info>)
List 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 by date:

Previous
From: "pgAdmin Trac"
Date:
Subject: [pgAdmin III] #167: Missing RULEs for VIEWs in SQL pane
Next
From: Thom Brown
Date:
Subject: Feature request: limited deletions