Missing RULEs from VIEWs and their format

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Missing RULEs from VIEWs and their format
Date: 2010-04-07 17:47:12
Message-ID: 4BBCC520.4070400@falter.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Thom Brown 2010-04-08 10:06:18 Feature request: limited deletions
Previous Message pgAdmin Trac 2010-04-07 17:38:48 [pgAdmin III] #167: Missing RULEs for VIEWs in SQL pane