Re: Missing RULEs from VIEWs and their format

Le 07/04/2010 19:47, Erwin Brandstetter a écrit :
> [...]
> 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;
>

Hummm, /me feels ashamed but happy to see you came back with so many bug
reports and feature requests :)


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com